Oh, and where would I put the following paging code within the script?
my $pageNum = $IN->param('page') ||= 1;
# number of links per page
my $linksPP = 10;
my $end = $linksPP*$pageNum;
my $start = $end - $linksPP;
$tab->select_options('LIMIT $start OFFSET $end');
Code:
my $pageNum = $IN->param('page') ||= 1;
# number of links per page
my $linksPP = 10;
my $end = $linksPP*$pageNum;
my $start = $end - $linksPP;
$tab->select_options('LIMIT $start OFFSET $end');