I am issuing the following command in PHP to a Mysql db
mysql_query("UPDATE dbname SET read_count=read_count + 1 WHERE id = 10");
The problem is, that the number in the field read_count increments by 2 everytime. So if read_count = 0, after the command it will say read_count=2
I have the db field set to INT with no other attribute. Is this a MYSQL bug or am I missing something?