RE: [PHP] next and previous buttons performing on a query
you need to keep track of the last record and number to display to work out the values for limit. > -Original Message- > From: Chris Hewitt [mailto:[EMAIL PROTECTED]] > Sent: 13 June 2002 3:32 PM > To: Wilbert Enserink > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] next and previous buttons performing on a query > > > Wilbert, > > Use the LIMIT tag in your select statement. You can also choose which > matching record to start from. > > Another pure database question... > > HTH > Chris > > Wilbert Enserink wrote: > > >Hi all, > > > > > >I have this mySQL query giving me my result back. > > > >The info about the current db-record is showing. > >Now I want to display ' view next ' and ' view previous ' > buttons on my website. which takes you to the same page but > with the next record in the query result. > >Is there a clever way to do this? > > > >Any tips are welcome! > > > >Many regards > > > >Wilbert Enserink > > > >- > >Pas de Deux > >Van Mierisstraat 25 > >2526 NM Den Haag > >tel 070 4450855 > >fax 070 4450852 > >http://www.pdd.nl > >[EMAIL PROTECTED] > >- > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] next and previous buttons performing on a query
Wilbert, Use the LIMIT tag in your select statement. You can also choose which matching record to start from. Another pure database question... HTH Chris Wilbert Enserink wrote: >Hi all, > > >I have this mySQL query giving me my result back. > >The info about the current db-record is showing. >Now I want to display ' view next ' and ' view previous ' buttons on my website. >which takes you to the same page but with the next record in the query result. >Is there a clever way to do this? > >Any tips are welcome! > >Many regards > >Wilbert Enserink > >- >Pas de Deux >Van Mierisstraat 25 >2526 NM Den Haag >tel 070 4450855 >fax 070 4450852 >http://www.pdd.nl >[EMAIL PROTECTED] >- > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] next and previous buttons performing on a query
Hi all, I have this mySQL query giving me my result back. The info about the current db-record is showing. Now I want to display ' view next ' and ' view previous ' buttons on my website. which takes you to the same page but with the next record in the query result. Is there a clever way to do this? Any tips are welcome! Many regards Wilbert Enserink - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] -