I Need Help With Suming Up Integer Data Values Fetch From My Database

[talk2toyin]

Here's my source code please.....

$sql = "select c_load from accndi_i";

$res = mysql_query($sql);

while($credits = mysql_fetch_assoc($res)) {

while($currentcredit = each($credits)) {

echo $currentcredit["value"]."+";

}

}

/*but, what i really want is to sum up the values fetched from my c_load column in my accndi_i table.

Assistance urgently needed please. Thanks

*/

Edited October 12, 2012 by talk2toyin

[mikosiko]

use mysql SUM() function

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_sum

 

and if that doesn't help... a practical example

http://www.tizag.com/mysqlTutorial/mysqlsum.php

[talk2toyin]

Wow! Thanks alot. It worked out just fine.

The funny thing is, I know of that sum function....but I just never crossed my mind I could apply it there. Thanks again, u're a life saver.