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


in reply to Viewing

Hejsan

This was asked before and a good answer was given but I cant remember the author so you'll have to search it.

The proposed solutions was how I would of done it - do it via SQL.

You can use the LIMIT keyword to show a subset of the data returned. For example:

SELECT * FROM mydata LIMIT 100,100;

Here, it tells it to show from the 100th record (1st number) and only 100 records (2nd).

I would approach it by making your "next" link append the next number for limit. Pseudo code may look something like:

my $blocksize = 100; my $limit = 1 + param("limit"); #get the value from the query stri +ng my $sql = "SELECT * FROM data LIMIT $limit,$blocksize;"
Then your next and back buttons may have links like:
showdata.pl?limit=200
showdate.pl?limit=0

Add garnish as desired...

- Jed