Re: Next and Preview Row

Yes, but how to get ONLY the 3 records you need ? Because often in an application, you don't care about the other records. In this case AFAIK, there is no other solution than issuing at least two queries : SELECT * FROM table WHERE field<='ID00025' ORDER BY field DESC LIMIT 2 SELECT * FROM table WHERE field>'ID00025' ORDER BY field ASC LIMIT 1 ----- Original Message ----- From: "Chris Boget" <chris@wild.net> To: "Fournier Jocelyn [Presence-PC]" <joc@presence-pc.com>; "Raymond Gubala" <gubala@dca.durhamc.on.ca>; "Mark Lo" <markloky@netvigator.com>; <mysql@lists.mysql.com>; <php-general@lists.php.net> Sent: Friday, February 22, 2002 9:17 PM Subject: Re: [PHP] Next and Preview Row > > It seems worst to me because in your case mysql has to retrieve all the > > rows. If it's a table with 1 million records or more, this should hurt ;) > > As I said, it was pseudo code. Now, imagine that you were just > getting the records for a particular user? a particular application? > Where there won't be millions and millions of rows? > > Chris > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <mysql-thread100787@lists.mysql.com> > To unsubscribe, e-mail <mysql-unsubscribe-joc=presence-pc.com@lists.mysql.com> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > >