Mysql Count Calculation

[eugene2009]

Hello, i have a script that records pageviews.. everything works great it does an insert if not exists, and it updates +1 if it does.. thats not the problem though..

 

for example..

 

row1 - 6

row2 - 5

row3 - 8

row4 - 2

row5 - 9

 

What code can I use that will automatically give me the sum of all the rows (6+5+8+2+9, etc.)

because those numbers will always be updated and I want a total that will be updated please help

[eugene2009]

?

[teamatomic]

SELECT  SUM(visits) FROM count GROUP BY visits";

or something like this

 

 

HTH

Teamatomic