PHP - Page Counter

[cancer10]

Hi

I am trying to create a page counter in PHP.

Table structure:

Table Name: tbl_counter
Column Name:total_views
Column Datatype: integer

I am using the following SQL query on the page.

UPDATE tbl_counter SET total_views=total_views+1

I know its weird but, sometimes the counter increases twice instead of 1, any idea why?

[Xnuiem]

try tossing a limit 1 onto the end of the sql statement.

I agree it is very odd, but that may clear it up.

[vbplusme]

I am guessing a page refresh.

I tested this query with over 100K loops and it never double stamped so I am thinking that you may have done a page refresh to get the extra count? Just a guess.

Here is my query:

PHP Code:


$query = "UPDATE `tbl_counter` SET `total_views`= `total_views`+ 1 ";
mysql_query($query) or die('Error, query failed'); 


I stuck it in a for loop to see if it would add any extra updates and it did not.

HTH,

vbplusme

[Xnuiem]

That is an excellent thought!! The query does look fine to me as well.

What are you doing in the webpage after you run the query? Going to the same place or are you redirecting to keep the refresh problems from happening?