ra: <[EMAIL PROTECTED]>
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 th
nd 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: [
:40 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] retrieval of NEXT, PREV records
>
>
> As far as I know, if you do not set any special order, the table
> is ordered
> by primary key, isn't it ?
>
> Jayme.
>
>
> -Mensagem Original-
> De: Ch
>
Enviada em: quarta-feira, 21 de 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, Februar
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
01 11:41
Assunto: [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
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 rec
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
