How to get 'Total of columns returned'

let's saymy select statement returns three rows... THEY contain an integer field call 'bucks' ...

100
2
22

HOW can i total the contents of this column to achive the result of

124

$total += $row['bucks'];

DOESN't SEEm to work.

Help

Fritz

Did you initialize $total to 0 before you added to it? That's just a wild guess, you didn't post enough information to give a proper answer.

That's approach is really a detour. Use the functions of the database whenever possible.

Do a query like "SELECT SUM(somefield) FROM sometable" and you don't have to do any summing with php.

Your method should work, but I'm not going to try to guess what's wrong. Lets see some code if you insist on having PHP doing tha adding.

Disclamer: It's 3.45am, and I really should be sleeping...

not much code really... i am a newbie inching along,

SELECT SUM(somefield) FROM sometable

may just be all I need.

let me give it a go... THANKS tomhath and Spork for responding.

Fritz Jung
Co-Founder - The Witches' Voice
http://www.witchvox.com