Counting values

[Anon]

I know it's possible to count the number of rows in a MySQL query using count(blah), but is it possible to add up all the values in a column.

If I use this statement:

select time from fixtures_subs WHERE replaced='$name'

Is it possible to add up all the values in the column time?

So, if the results are

time

56
43
88
40

is there a way of returning 227?

[djg_uk]

Hi Richard,

Try using SUM().

Regards,

David

[Anon]

That's quite right. Just a hint - read MySQL manual about functions which you can use in SELECT statement - there is a number of pretty useful functions.