http://www.perlmonks.org?node_id=239825

powerhouse has asked for the wisdom of the Perl Monks concerning the following question:

I am using a MySQL database and counting the rows in the database.

$count now contains the number of records in the database.
Can someone show me a sample of how I would go about creating links to each page, if $start_limit contains the starting number. For example, $count = 200; and $start_limit = 20; $start_limit is the number of records to show on the page.

How can I get a page navigation system out of that? I keep confusing myself, so I need some help. I would really appreciate it. I want it to put the number of pages, for instance with the numbers above it would do something like this:

1 2 3 4 5 6

Where it will NOT put a link for the page it is on. I have been trying various things for about 2 hours now and am getting so frustrated. I'd really appreciate some advice on modules or something that already do this, or just a simple way to do it.

thx,
Richard