Re: re:mysql help #1

Thanks! That was exactly what I was looking for! "Andras Balogh" <abalogh@grafx.ro> wrote in message news:011f01c11b39$174c0b70$0d00a8c0@grafx.ro... 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. >