листване на страниците

<?php 
$sql = "SELECT COUNT(id) FROM offerts WHERE o1=2"; 
$rs_result = mysql_query($sql); 
$row = mysql_fetch_row($rs_result); 
$total_records = $row[0]; 
$total_pages = ceil($total_records / 2); 
  
for ($i=1; $i<=$total_pages; $i++) { 
            echo "<a href='sell.php?page=".$i."'>".$i."</a> "; 
}; 
?>

<<  [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15  >>

$current = array_key_exists("page", $_GET) ? (int)$_GET['page'] : '1';

if ($current > 1) {
    $prev = $current - 1;
    echo '<a href="sell.php?page=' . $prev . '"><<</a> ';
}

for ($i = 1; $i <= $total_pages; $i++) {
    if ($i == $current) {
      echo "[ <a href='sell.php?page=".$i."'>".$i."</a> ] ";
      continue;
    }

    echo "<a href='sell.php?page=".$i."'>".$i."</a> ";
}

if ($current < $total_pages) {
    $next = $current + 1;
    echo ' <a href="sell.php?page=' . $next . '">>></a>';
}