Wouldn't it be:
mysql_query("UPDATE database set Field = Field+1 WHERE
Criteria='Criteria'");
Note: no '' around +1, = operator
John Corry
admin@xxxxxxxxxxxxxxxxxxx wrote:
> Okay maybe i have just forgot.
> I am trying to update the database and do a +1 to a int field without pulling the data and adding 1 to it and sticking it back in.
>
> Someone refresh me on this please.
> I think it is something like.
> $dwsl = mysql_query("UPDATE database set Field='+1' WHERE Criteria='Criteria'");
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
