Add up total SUM()

[Craig Hopson]

hi all cant get this to work where am i going wrong?

$result = mysql_query("SELECT SUM(malai) FROM orders WHERE delivery = 0");while($row = mysql_fetch_array($result))  {echo $row['malai'];   }

i get Resource id #7 from this what i want is to add the total from colum and then echo it

[niche]

According to http://www.w3schools...ql_func_sum.asp you'll get is a single number so you probably won't have to put your fetch array in a while loop. Echo a var_dump() after your fetch array to see how to get access to your number. Also, always put

or die(mysql_error());

after your queries for more complete error reporting.

Edited September 1, 2012 by niche

[JamesB]

Also if you're looking to access the total number via a string into $row, instead of an integer into $row, you should use the 'as' keyword in the query:http://www.w3schools.com/sql/sql_alias.asp eg.

SELECT SUM(malai) AS malai FROM orders WHERE delivery = 0

[Craig Hopson]

So what would I echo then?

[JamesB]

$row['malai'] The string given to $row should match the one used after 'AS' in the query.

[Craig Hopson]

$row[`malai`] don't work

[Craig Hopson]

how about thisSOLVED

$result = mysql_query("SELECT SUM(malai) FROM orders WHERE delivered = 0");while($row=mysql_fetch_array($result)){echo $row['SUM(malai)'];}

but instead of while loop how else could this be done?

Edited September 1, 2012 by Craig Hopson

[JamesB]

$result = mysql_query('SELECT SUM(malai) AS total FROM orders WHERE delivered = 0');$row = mysql_fetch_assoc($result);echo $row['total'];

$result = mysql_query('SELECT SUM(malai) FROM orders WHERE delivered = 0');$row = mysql_fetch_row($result);echo $row[0];