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
|