# 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]

gav^

What you do instead is use the values in the columns of the row you currently have and apply them judiciously in a WHERE clause to get the preceding or following row, based on the ORDER BY clause that you specify.

Remember that a relational database is based on set theory, so rows in a table aren't in a specific position - they are part of a set.

That said a lot of RDBMS systems have pseudo rownumber indicators (I know that Oracle has this) that you can use. It's possible that MySQL has something similar.

Michael