The query works fine on it's own, but generates a SQL error in my page: SELECT * FROM MemberRez WHERE LurkID=colname (I've tried it without this line) ORDER BY andnext asc limit 1,1
andnext is the pk auto inc. Page error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT -1' at line 1 Maybe formatting ? Stuart --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
