DaveLinger Posted October 21, 2006 Share Posted October 21, 2006 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! Quote Link to comment Share on other sites More sharing options...
akitchin Posted October 21, 2006 Share Posted October 21, 2006 [code]SELECT SUM(hits) AS total_hits FROM table[/code]the MySQL manual has a whole host of functions to use. check the manual. Quote Link to comment Share on other sites More sharing options...
DaveLinger Posted October 21, 2006 Author Share Posted October 21, 2006 I checked it and couldn't find much of anything... thanks for the help; I'll check more closely next time. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.