Re: [PHP] Next and Preview Row

ELECT * FROM table 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]>; "

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