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.

-----Original Message-----
From: Adv. Systems Design <[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?
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail - only $35
>a year!
>PHP Database Mailing List (
>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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to