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
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
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
o: [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