Re: [PHP-DB] next & previous record

2001-02-22 Thread JJeffman
tispam.html -Mensagem Original- De: Andrew Hill <[EMAIL PROTECTED]> Para: Dreamvale <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Enviada em: quinta-feira, 22 de fevereiro de 2001 14:10 Assunto: RE: [PHP-DB] next & previous record > You want to use Cursor

Re: [PHP-DB] next & previous record

2001-02-22 Thread Lennin Arriola
Keep a counter of the rows you have fetched. so when you want to go back call mysql_data_seek ($Result, Counter-1); then mysql_fetch and you've got the previous row. Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [E

RE: [PHP-DB] next & previous record

2001-02-22 Thread Andrew Hill
w.com > -Original Message- > From: Dreamvale [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 22, 2001 11:42 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] next & previous record > > > I was not refering pagination. > > suppossing there are these 3 reco

Re: [PHP-DB] next & previous record

2001-02-22 Thread Dreamvale
I was not refering pagination. suppossing there are these 3 records ABC DEF GHI LJK now a search is done by entering D, which using like & %, and limit would return the record DEF. The "next" would forward to GHI and "previous" would backward to ABC. any idea? thanks. - Original Message