MySQL (TOTAL)

[prokhaled]

I have this table:

ID SUM
1 2
2 5
3 3


There is any function to give me the total of SUM column:
2+5+3=10

I can calculate them using math such as $i=$i+$row[sum] .. but I ask about function to do that auto.

Thanks...

[scoutt]

you could put those into an array and then add them that way using array_sum()

or when you pull them out of the DB you can add them to each other like you are doing.

[HeaveNGuY]

I think you can also use:


select sum(columnName) as variable from table;

You can use that query and i think the value will be stored in the variable $variable.

[ubunreal69]

or just run a loop that will add them together. I'll post an example in a moment

[ubunreal69]

wouldn't something like this work:

$x = 0;
$the_sum = 0;
While ($x < mysql_num_rows($query))
{
$the_sum = $the_sum + mysql_result($query,$x,"sum");
$x++;
}

ECHO "Sum of row: $the_sum"; 

?

[scoutt]

yup that could work but HeaveNGuY has the right idea. besides using mysql_result is a lot slower then using sum()