That would actually work for just getting a certain number of records from a
query, but you would have to execute another query to figure out the navigational
links he said he wants on the bottom...like google has, << 1 2 3 4 5 >>. So,
when I attacked it I figured one query is better then two even if it returns a
whole bunch of records in the result that you are not using for that page. How is
that for performance? which would be better? Or even, is there an alternative
way to figureing out how many records are in a database? Always more then one
way to skin a cat.
Mark Lee wrote:
> 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?
> Lucas Novæ Matrix wrote:
> >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)
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php