[snip] > is there a way I can get a number and increment it all in one query > then? > > UPDATE tblFoo SET value = (value+1) WHERE conditions >
Hmm.. my bad - I get that bit, but can I do: SELECT value WHERE conditions UPDATE tblfoo SET value= (value+1) [/snip] I see where the confusion may be now...where is that value you were looking for? Its in the conditions... UPDATE tblFoo SET value = (value + 1) WHERE value = 'blork' AND otherStuff = 'fark' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
