*SOLVED*Add the amount specified in a certain column of all rows in mysql?

[DaveLinger]

so I'm working on a hit counter, and basically each IP address gets its own row in the table, containing info about browser, platform, as well as their ip address and how many hits have come from that IP address. So for instance I may have a row with the column "hits" having the value "230" and on another row the value is "12". How would I write an SQL query to get all the results for my "hits" column and add them into a variable?

Thanks!

[akitchin]

[code]SELECT SUM(hits) AS total_hits FROM table[/code]

the MySQL manual has a whole host of functions to use.  check the manual.

[DaveLinger]

I checked it and couldn't find much of anything... thanks for the help; I'll check more closely next time.