Wouldn't it be: mysql_query("UPDATE database set Field = Field+1 WHERE Criteria='Criteria'");
Note: no '' around +1, = operator John Corry ad...@buskirkgraphics.com 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