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]