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