Sum up a column

[Anon]

How can I?

1. Sum up columns values
2. Store it in a variable

Thanks / Henrik

[Anon]

check the mysql.com site for sure on the syntax, but I think it is something like:

select sum(column_name) from table_name

then use php to convert the returned query to a variable.

[Anon]

thank you!