Strange counter problem (for article read count)

[MattG]

Got a strange one, every time someone reads an article through a script I'm doing it's supposed to add one onto the viewed column of that entry in the mysql database.

However in Opera and Firefox it adds 2 onto the current number and only in IE does it add 1. Can't say I've ever run into this before.

The code is nothing special just...

mysql_query("UPDATE posts SET viewed = viewed+1 WHERE id = $articleid");

I even tried getting the viewed count from the database, setting it as a variable adding 1 and then using

mysql_query("UPDATE posts SET viewed = $viewed WHERE id = $articleid");

But still no luck, anyone with any ideas why it might be doing this. I've looked through all the code and nowhere else is the viewed column accessed or altered so it's not doing the query twice otherwise it would also add 2 in IE.

[sneakyimp]

That first query looks fine to me. Not sure about that second one. You haven't really showed us enough code to diagnose the problem.

[MattG]

I even tried a plain php file with nothing in it apart from that first query and it still did it. Quite strange.

[Horizon88]

Is it the way IE handles the cache settings, perhaps? How the PHP code runs shouldn't have any effect browser-to-browser; it's all server side.

[benracer]

if it needs to be accurate save the views into a session and run a query to check the session id...ect