Re: Locking mysql tables with PHP
| From: | Tony Crockford | Date: | Tue, 25 Nov 2003 13:21:13 +0000 |
| Subject: | Re: Locking mysql tables with PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-170875@lists.php.net to get a copy of this message | ||
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 conditionsHmm.. my bad - I get that bit, but can I do: SELECT value WHERE conditions UPDATE tblfoo SET value= (value+1) Thanks Tony