That was exactly what I was looking for!

"Andras Balogh" <[EMAIL PROTECTED]> wrote in message
news:011f01c11b39$174c0b70$[EMAIL PROTECTED]...

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,


"elias" <[EMAIL PROTECTED]> wrote in message
> 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.

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to