in reply to Number of listings per page
One of the things you might want to do as well is pass a direction for your pagination... you wouldn't want to limit users to only traversing forward through your records right? Pass a param called "direction" or "dir" set to either "fwd" or "rev" and set your offset accordingly.my $offset = url_param('offset') || 0; my $sth = $dbh->prepare("SELECT * FROM foo WHERE something = 1 LIMIT 1 +5 OFFSET $offset"); my $rv = $sth->execute(); my @data; if($rv && ($rv ne "0E0")){ while($_ = $sth->fetchrow_hashref()){ push @data, $_; } $sth->finish(); } #set up the offset for the next page $offset += 15;
|
|---|