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

Reply via email to