Re: [PHP] Next and Preview Row

Hi, 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 ;) Regards, Jocelyn Fournier Presence-PC - Original Message - From: Chris Boget [EMAIL PROTECTED] To: Raymond Gubala [EMAIL PROTECTED];

Re: [PHP] Next and Preview Row

WHERE field'ID00025' ORDER BY field ASC LIMIT 1 - Original Message - From: Chris Boget [EMAIL PROTECTED] To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]; Raymond Gubala [EMAIL PROTECTED]; Mark Lo [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 22, 2002 9