Perhaps it is ordered that way, perhaps not, but live by the creed "Expect
nothing and 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, if you do not set any special order, the table
> is ordered
> by primary key, isn't it ?
>
> Jayme.
>
>
> -----Mensagem Original-----
> De: Chris Book <[EMAIL PROTECTED]>
> Para: JJeffman <[EMAIL PROTECTED]>; Adv. Systems Design
> <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> 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, February 20, 2001 4:39 PM
> > To: Adv. Systems Design; [EMAIL PROTECTED]
> > Subject: Re: [PHP-DB] retrieval of NEXT, PREV records
> >
> >
> > "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: terça-feira, 20 de fevereiro de 2001 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 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]
>
--
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]
