re:mysql help #1
| From: | Andras Balogh | Date: | Thu, 02 Aug 2001 09:54:15 +0000 |
| Subject: | re:mysql help #1 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-60876@lists.php.net to get a copy of this message | ||
Hi,
Use limit :
update mytable set status='Reserverd' where purch_id=1 limit 3;
This is mysql specific i think so it won't work with other db.
Best wishes,
Andras.
"elias" <elias_bachaalany@yahoo.com> wrote in message news:20010802093440.68853.qmail@pb1.pair.com...
> Someone purchased items from my site let's say 3 items out of 5 total. All
> items are the same. I just want to update 3 items status to "Reserved".
> When he buy he just tell how many and not which ones.
>