Is there a way I can get a set of records incrementally such as to get 2
then the next query get the next 2 then at the end of all records to get the
2 from the beginning? I need to keep going incrementally by 2 in a circle.
Thanks
Steffan
- Original Message -
From: Steffan A. Cline [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, May 12, 2006 1:38 PM
Subject: Returning records in a circle
Is there a way I can get a set of records incrementally such as to get 2
then the next query get the next 2
@lists.mysql.com
Subject: Re: Returning records in a circle
- Original Message -
From: Steffan A. Cline [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, May 12, 2006 1:38 PM
Subject: Returning records in a circle
Is there a way I can get a set of records incrementally such as to get
Is there a way I can get a set of records incrementally such as to get 2
then the next query get the next 2 then at the end of all records to get the
2 from the beginning? I need to keep going incrementally by 2 in a circle.
I don't know any way to do this directly with SQL, but I could be
@lists.mysql.com
Subject: Re: Returning records in a circle
Well, basically it can be done to an extent in some kind of code.
Basically
I am drawing from a table 2 records at a time. I want to make sure that
all
records are pulled at least once. If at all possible not to have 2 from
the
same vendor.
So
--
Rhino
- Original Message -
From: George Law [EMAIL PROTECTED]
To: Steffan A. Cline [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, May 12, 2006 3:33 PM
Subject: RE: Returning records in a circle
I ran into this same type of question the other evening at a local
linux group.
I