$sth = $dbh->prepare('SELECT ... FROM ... WHERE ... LIMIT ?,?') or die "...";
$sth->execute(..., param('start') || 0, param('number') || 10) or die "...";