How about appending " LIMIT _GET[startrow],5" to the end of your query.
The first parameter to LIMIT is the start position and the second is
the number of rows to return.
Does this help, or am I misunderstanding your question?
Mark
Lucas Novæ Matrix wrote:
>Hello,
>
>I am trying to create a "next n" interface through php4, using results from
>a mysql query. I did this in the past easily with ColdFusion, but this time
>it's a bit more complicated.
>
>What I need to do basicaly is to have only 5 results per page. The first
>page displays the 5 results and "Next Page >>>" at the bottom, the second
>page displays results 6 to 10 and displays "<<< Previous Page | Next Page
>
>>>>" , up until the last page that displays only the previous page, and the
>>>>
>last results (from 1 to 5).
>
>I don't necessarely need to have each page as a number at the bottom, just
>the previous and next links. All I need basically is to either get or output
>only 5 rows at a time, with only needing the $_GET['startrow'] variable.
>
>Can anyone help me? (or just throw me a link to an existing page/script)
>
>Thanks,
>Éric.
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
