[SOLVED] Adding all the values up in one column?

[L]

Hey,

I want to figure out the total sum of all the values in the column, `amount`. I'm not sure how I would go about doing this.

 

I have

$donated = mysql_fetch_array(mysql_query("SELECT * FROM `donations` WHERE `month`='".date('m-Y')."'"));

but when I echo out $donated['amount'] it just echos out the latest insert.

 

thanks for your time

~L

[rajivgonsalves]

your code should be

 

$donated = mysql_fetch_array(mysql_query("SELECT sum(`amount`) as amount FROM `donations` WHERE `month`='".date('m-Y')."'"));

 

use the mysql sum function

[L]

Sweet, thanx!

That solved it.