Mysql help

[rascle]

Hi

I am using the following code:

$id = $game['gamenumb'];

mysql_query("UPDATE games SET hits = hits+'1'

WHERE gamenumb = $id");

 

which, when a page is viewed the code will +1 to a row in a MySQL db. However for some reason it is adding 2 instead of 1? Does anyone know why this is?

Thanks

 

[inversesoft123]

change it to hits=hits+1

[rascle]

for some reason it is still adding 2 ??

[rascle]

i dont know why it is doing this, i have checked everywhere else to make sure that i am not adding +1 somewhere else

[inversesoft123]

mysql_query("UPDATE games set hits=hits+1 where gamenumb='$id'");

[rascle]

Thanks!