Thanks! That was exactly what I was looking for! "Andras Balogh" <[EMAIL PROTECTED]> wrote in message news:011f01c11b39$174c0b70$[EMAIL PROTECTED]... 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" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]