Posted by John Nichel on 03/23/05 22:27

Marquez Design wrote:
> Hello all,
>
> I am wanting to paginate records from a MySQL Database.
> I want there to be 5 records on a page, on multiple pages.
>
> Can someone point me in the right direction or show me a way to do this?
>
> I can get five records on a page with a LIMIT statement, however, I can not
> get it to show the first five, then put a "next" link to the next 5 and so
> on.
>
> (I would like there to be a "next" and "previous.")

Your next and previous buttons either need to pass where they left off
in the db (either in the query string or by means of a form post), so
that your script will know where to start from.

--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@kegworks.com

[Back to original message]