SUM

[Anon]

How do I calculate a SUM value of a column?

...and...

How do I calculate a SUM value of one column where number of rows was limited by SELECT

Thanx
Blaz

[[deleted]]

How about reading the manual for your database?
Som manuals actually list functions like these...

[Anon]

$sqb = mysql_query ("SELECT SUM(NAMEOFYOURCOLUMN) as total
FROM NAMEOFTABLE");
list ($total) = mysql_fetch_row($sqb);

echo "$total";

[[deleted]]

Does it make sense to reply to a post that's 10 months old?

[macsurfer]

Does it make sense to be so rude? You waste more time criticizing other people about NOT reading the manual than contributing to the threads. Did it ever occur to you that maybe some of these people have READ the MANUAL and may still not be clear on the subject?

[Anon]

i found the reply helpful, thnx Tyler

[Anon]

So did I...and gee it's older than 10 months now! :o)

Marcel

[Anon]

It has been over a year now since the orignal post, and thank you tyler for your help.

[claire]

Good contributions live forever!
This was exactly what I was looking for!
Thanks Tyler.

[Anon]

Just what I was looking for. Thanks again Tyler