Say it with me: "The manual is your friend. The manual is your friend. The manual..." - (it just bit me, too, on another thread) LOL
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Stuart Felenstein <[EMAIL PROTECTED]> wrote on 09/02/2004 11:02:06 AM: > Wait!!!!!!!!!!!!!! Don't answer...it's that LIMIT > thing. > > > :) > Stuart > > > --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > > > I'm tring to extract all records belonging to one ID > > in a table. > > BUT! I want to do it in piece meal. Meaning a > > record > > at a time. > > I am assuming I need some kind of count mechanism. > > > > Example: > > I want to see the first 3 purchases this member > > made. > > Instead of grabbing them all in one shot, I want to > > break those 3 out in 3 seperate results set > > > > Results Set1: Purchase 1 > > Results Set2: Purchase 2 > > Results Set3: Purchase 3 > > > > This is probably easy. > > > > Thank you, > > Stuart > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >