add the contents of a column

[kooks]

I konw this should be easy, but I can not find any documentation on it. I need to add the contents of a MySQL Column.

EXAMPLE

sql="SELECT votes FROM mytable WHERE candidate='Fred'";

How can I add up all the integers in the "votes" column

Even the URL to some good documentation would be welcome.

Thank You,

[Lars_Berg]

sql="SELECT sum(votes) FROM mytable WHERE candidate='Fred'";

To get votes for all candiates

sql="SELECT sum(votes),candidate FROM mytable
group by candidate";

[kooks]

You saved me hours.

Thank You Lars!