Check for a return code from the (I assume you are using a relational database) database stating a row was not found. If the condition is true, then re-execute the ID+1 or ID-1 code to select the next row in sequence. You can keep looping through this until you get a return code from the database that states a row was found. Peter -----Original Message----- From: Adv. Systems Design <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, February 20, 2001 9:41 AM Subject: [PHP-DB] retrieval of NEXT, PREV records >I have set up links to browse records one by one, >using (ID+1) for NEXT and (ID-1) for PREV...the only >problem is that if there is a hole in the ID sequence >(as from DELETION), there is no record returned...How >can I have it so that the 'holes' are paved over and >not returned? > >TIA > >Luis > >__________________________________________________ >Do You Yahoo!? >Get personalized email addresses from Yahoo! Mail - only $35 >a year! http://personal.mail.yahoo.com/ > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]