adding values of a single column

[utinaeniduin]

how can i add all the values of one column of the table to get a total?

[koyama]

SELECT SUM(myColumn) FROM myTable WHERE 1

[guelphdad]

Note that the WHERE 1 is not necessary.

[utinaeniduin]

cool. now how do i store that sum in a variable?

[koyama]

I guess you are using php?

PHP Code:

$sql = "SELECT SUM(myColumn) FROM myTable";
$result = mysql_query($sql);
list($sum) = mysql_fetch_row($result);   // now $sum = 'the sum'