you have to make sure you order by Rec_id all the time too.
-Original Message-
From: JJeffman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 4:39 PM
To: Adv. Systems Design; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] retrieval of NEXT, PREV records
"SELECT * FROM Table
fevereiro de 2001 11:16
Assunto: RE: [PHP-DB] retrieval of NEXT, PREV records
you have to make sure you order by Rec_id all the time too.
-Original Message-
From: JJeffman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 4:39 PM
To: Adv. Systems Design; [EMAIL PROTECTED
d you will never be disappointed."
Go ahead and specify the order you demand.
-Original Message-
From: JJeffman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 4:40 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] retrieval of NEXT, PREV records
As far as I know,
]
Enviada em: quarta-feira, 21 de fevereiro de 2001 19:06
Assunto: RE: [PHP-DB] retrieval of NEXT, PREV records
It would only be ordered that way if you had not
deleted any records and added new ones. IF there
are ones deleted, the next ones frill in the space.
Bob
At 05:00 PM 2/21/01 -0500
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
"SELECT * FROM Table WHERE Rec_id $recid LIMIT 1" always bring you the
next record no matter the Rec_id is.
HTH
Jayme.
-Mensagem Original-
De: Adv. Systems Design [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: tera-feira, 20 de fevereiro de 2001 11:41
Assunto: [PHP-DB]