'Pagination'

[Jim02]

Howdy Folks,

I'm currently writing a script, and it will have a lot of entries, but I need a way to figure out how many pages there are from all of the entires into the MySQL database. I want to show approximately 25 (rows) per-page, but that could change at any time.

I have tried a couple different methods, but none without significant bugs in them. Some not showing all the pages, some showing too many pages.

Can anyone help me with this?

Any help would be appreciated.

[kamy99]

The concept is this:

Use Limit and couple of variables in your queries

$desired_limit=25;
$Start=0

sql="Select * FROM table_name LIMIT $desired_limit , $Start"

{display data}

$Start=$Start+$desired_limit;

HTH

[cgraz]

Here's a post with sample code that actually works.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10224747

Cgraz