syntax problem

[jenodorf]

Hi really sorry to be so dense , but I'm trying to get my head around PHP and mysql.

I have a mysql database and need to calculate a total stock value and display it in a web page.

Searched the web, asked here and been through a couple of books but I'm struggling.

The code I'm trying to use is as follows:-

<?php
Select sum (SKU_price * SKU_stock) as totalStockValue from tbl_skus;
echo totalStockVale;
?>

I've inserted this into a PHP admin page which is already logged onto the database.

I thought that LIne one created a value for the total stock called totalStockValue and line two echoed the result to the screen.

Is my logoc totally wrong?

thanks

Ian

 

[jpadie]

your first line is a sql statement, not a php function. you would need to do something like this instead

mysql_connect($host, $user, $pwd);
mysql_select_db($dbname);
$result = mysql_query('Select sum (SKU_price * SKU_stock) as totalStockValue from tbl_skus') or die(mysql_error());
$row = mysql_fetch_assoc($result);
echo "Total is ". $row['totalStockValue'];

obviously you will need to fill the first two lines with your own values for your database.

 

[jenodorf]

Thanks,

appreciate the help, I'll try it tomorrow.

Wish I could find a good reference guide on using php with mysql and HTML

I'm ok on HTML but the mysql bit is an uphill road

cheers

Ian

 

[jpadie]

look at the user contributed notes to mysql_query in the php manual.

http://www.php.net/mysql_query.

the php manual is by far the best place to learn about php.