add all values in a column (mysql)

[Anon]

Hey guys,

I am trying to add all of the values together that are in a column of my table. Is there any built in function for this in php or mysql? I am having trouble trying to create my own with php.

Thanks,

Ben

[rrijnders]

SELECT SUM(columnName) AS myTotal FROM tableName

-- Rich