Jump to content

Archived

This topic is now archived and is closed to further replies.

DaveLinger

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

Recommended Posts

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!

Share this post


Link to post
Share on other sites
[code]SELECT SUM(hits) AS total_hits FROM table[/code]

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

Share this post


Link to post
Share on other sites
I checked it and couldn't find much of anything... thanks for the help; I'll check more closely next time.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.