[SOLVED] Totaling "sum" of a field

[PJ droopy pants]

I am trying to get a total money from the users database and am having a hard time. I know how to get the total users by doing this..

$result = mysql_query("SELECT * FROM `users` ORDER BY `id` ASC");
$totalusers = mysql_num_rows($result);

 

but how do I total their `money` from that field in the table?

[mada9369]

$result = mysql_query("SELECT * FROM `users` ORDER BY `id` ASC");
$totalusers = mysql_num_rows($result);

while($row = mysql_fetch_array($totalusers)){
$money = $row['money'];
echo $money;

 

?!?

[PJ droopy pants]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource  :-\

[corbin]

This is MySQL related more so than PHP Math....

 

 

Anyway, to get the sum of the entire table:

 

 

SELECT SUM(money) FROM users;

[PJ droopy pants]

I tried

$result = mysql_query("SELECT SUM(money) FROM `users'");
$totalmoney = mysql_fetch_array($result);

 

but getting a Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

[GingerRobot]

You've mixed your quote types in your query. Backticks can be used to demarcate fields and table names whilst standard quotes are used to delimit strings:

 

$result = mysql_query("SELECT SUM(money) FROM `users`") or trigger_error(mysql_error(),E_USER_ERROR);
$sum = mysql_result($result,0);
echo "Sum of the rows is $sum";

 

 

[PJ droopy pants]

Thank you 

[corbin]

No problem.