sum the mysql returned value

[funbinod]

i want to know how to sum the numbers returned from a php query of mysql data. please guide through...

[Ingolme]

Do you know how to sum a set of numbers in an array?

[funbinod]

is it like -->

$array = array(1,2,3,4,5);$sum = array_sum($array);echo $sum; // 15

[Ingolme]

Well, that's one way to do it, but the query wouldn't work like that.

 

You have to loop through all the query results, adding on each iteration:

// Assuming PDO is being used for the database query$sum = 0;while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {    $sum += $row['value'];}echo $sum;

[CUBEDWELLERS]

Hello,

Pls, my root@localhost lost privileges. I might have mistakenly done that. Please help, i cant do anything in mysql right now. I cant CREATE, SELECT and all other privileges are gone. Pls help.

Thanks

[funbinod]

Hello,

Pls, my root@localhost lost privileges. I might have mistakenly done that. Please help, i cant do anything in mysql right now. I cant CREATE, SELECT and all other privileges are gone. Pls help.

Thanks

you should post a new topic. dont ask any question on any other topic....

[thescientist]

Hello,

Pls, my root@localhost lost privileges. I might have mistakenly done that. Please help, i cant do anything in mysql right now. I cant CREATE, SELECT and all other privileges are gone. Pls help.

Thanks

 

you should post a new topic. dont ask any question on any other topic....

 

he did, prior to posting here

http://w3schools.invisionzone.com/index.php?showtopic=50420

 

@CUBEDWELLER.

Please respect other threads unless you have something relevant to contribute otherwise, maintain the conversation in the thread you started for your topic. If you did, you would see you've already been giving an answer.