RE: [PHP] next and previous buttons performing on a query
| From: | Brian McGarvie | Date: | Thu, 13 Jun 2002 14:50:01 +0000 |
| Subject: | RE: [PHP] next and previous buttons performing on a query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-101971@lists.php.net to get a copy of this message | ||
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:g0pae@manordat.demon.co.uk]
> Sent: 13 June 2002 3:32 PM
> To: Wilbert Enserink
> Cc: php-general@lists.php.net
> 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
> >info@pdd.nl
> >-------------------------
> >
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>