I have a row in mysql called 'totalclicks' that is for every users. The totalclicks stores the hits for every visitors. I want to SUM up all the hits in the totalclicks for every user in the database, I mean every user has diffrent hits value. I tried using SUM() but seems not working. Anyone know how it would work?

Thankx