Keep track. Pass a skip parameter and skip that many records with LIMIT skip, records-per-page. For example:

# get number to skip over
my $skip = $cgi->param('skip') || 0;

# build SQL statement
$sql .= "LIMIT $skip, 10";

# build up links
$cgi->param('skip', $skip + 10);
my $next_link = (@results >= $10 ? $cgi->self_url : undef);

$cgi->param('skip', $skip - 10);
my $prev_link = ($skip > 0 ? $cgi->self_url : undef);
[download]

Hope this helps...

gav^