update field = field + 1; On Friday 04 June 2004 01:47 pm, Steven Morgan wrote: > is there anyway to add 1 to an int with 1 mysql query, i know i can pull > the value down with a SELECT then add 1 with php.. then do an UPDATE on > it.. but i didn't know if there was any other way? > thanks > Steve Mo' -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php