Re: [PHP] Locking mysql tables with PHP

[Tony Crockford]

On Tue, 25 Nov 2003 07:15:10 -0600, Jay Blanchard 
<[EMAIL PROTECTED]> wrote:

[snip]
is there a way I can get a number and increment it all in one query
then?
[/snip]
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)

Thanks

Tony

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php