[SOLVED] adding totals from mysql

[emma57573]

I want to add up some totals from a mysql column and output them onto a php page.

 

something like this

 

$total=mysql_fetch_array(mysql_query("SELECT sum=+(total) as total FROM my_table WHERE seller_id=$seller_id"));


echo $total;

 

I know thats completely wrong! its just for examples sake. If someone could help me with the right syntax that would be great.

 

Emma

 

 

[php_dave]

You were not far off 

 

$result=mysql_query("SELECT sum(total) as total FROM my_table WHERE seller_id=$seller_id");
$total = mysql_fetch_array($result);

echo $total;

[emma57573]

hum its still not working, the results are in decimals eg: 2.00, 4.00 etc

Might that be the problem?

[emma57573]

Im getting 'Resource id #218' instead of the result

[Mchl]

Try

echo mysql_error();

after executing query.

[emma57573]

ok not to worry Ive fixed it.

Thanks for the help

 

I used this:

$result="SELECT sum(total) as total FROM my_table WHERE seller_id=".$seller_id;
$php = mysql_query($result); 
if ($php) { 
$row = mysql_fetch_array($php); 

echo $row['total'];