[SOLVED] UPDATE with a +1

[burtybob]

mysql_query("UPDATE polls SET `vanswer1`=vanswer1+'1' WHERE `pkid`='$pollid'") or die(mysql_error());

 

That is my code and i get no error from the die(mysql_error()); part so im guessing there is no problem but why wont the field known as vanswer not +1??

 

Please can anyone help?

Any suggestions are helpful.

 

 

 

EDIT: think i realised whats wrong.

[pocobueno1388]

remove the quotes from the 1.

 

mysql_query("UPDATE polls SET `vanswer1`=vanswer1+1 WHERE `pkid`='$pollid'") or die(mysql_error());