Re: Locking mysql tables with PHP

From:	pete M	Date:	Tue, 25 Nov 2003 13:34:06 +0000
Subject:	Re: Locking mysql tables with PHP
References:	1 2	Groups:	php.general
Request:	Send a blank email to php-general+get-170876@lists.php.net to get a copy of this message

UPDATE tblfoo SET value= (value+1) WHERE conditions Tony Crockford wrote:

On Tue, 25 Nov 2003 07:15:10 -0600, Jay Blanchard <jay.blanchard@niicommunications.com> 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