previous & next buttons

[Psybar Phreak]

hi all,

im developing a site in perl with mason on a postgreSQL backend.

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.

can someone help me out.

thanks

PP

 

[Doc]

Yes, I would like to know how this can be done too.

 

[Psybar Phreak]

anyone?

PP

Yes, I would like to know how this can be done too.

 

[dw]

anyone? like

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...