Hi

Here is my question [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]


In my MySQL database, I have my content stored in a table called 'mainsite_main'. In that table there is also a column called 'hits' which keeps track of how many hits that particular item of content has had.

What I'm trying to do is select the entire column and add all the values together, to display the grand total amount of hits.


Thanks in advance for any help.

There's a mysql function to calculate the total of a field -- something like

SELECT SUM(hits) AS total FROM mainsite_main

(mainsite_main is a rather meaningless name, isn't it?)