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:
Then your next and back buttons may have links 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;"
showdata.pl?limit=200 showdate.pl?limit=0
Add garnish as desired...
- Jed
|
---|
In Section
Seekers of Perl Wisdom