anyone? Yes, I would like to know how this can be done too. i currently have a page that lists all items in a table, but would
like to do the
" << PREVIOUS 1 2 3 4 NEXT>> "
sort of thing - say LIMIT of 10 records to a page.
how about something along the lines of:
$q = new CGI;
$start = $q->param("start") || 0;
$count = 0;
while ($db->fetch) {
$count ++;
next while $count < $start;
last if $count = $start + 10;
print "item $count : **whatever you normally do**";
}
$MAX = $total_number_of_records_in_db;
print $q->a({href=>"?...&start=" . $start-10}, "<< PREVIOUS"), " ";
print $q->a({href=>"?...&start=" . ($_ * 10 + 1)}, "$_"), " " for
1..($MAX/10);
print $q->a({href=>"?...&start=" . $start+10}, "NEXT >>");
that should give you an idea on how you can do it... and if you can tell
your db to start at record number $start, that would be even better...
