[thelist] mysql/php: using the sum() function...i think

[Robert Gormley]

mysql_result - 

$query = "SELECT SUM(calories) AS calories FROM my_table";
$result = mysql_query($query);

print(mysql_result($result, "calories"));

You need the AS ... to make mysql_result cleaner.

HTH,
Robert
 

> Now I just want to be able to total up the calories and carbs 
> at the bottom.
> 
> I can do this at the mysql command line with:
> select SUM(calories) from my_table; or
> select SUM(carbs) from my_table;