$display = 24;
$num_pages = ($p_num>$display?ceil($p_num/$display):1);
$start = (isset($_GET['s'])?$_GET['s']:0);
if(!is_numeric($start) || $start<0) {
$start=0;
}
$sql = "SELECT * FROM table WHERE id='$id' LIMIT $start, $display";
if(!($result=mysql_query($sql))) { die(mysql_errno().": ".mysql_error()); }
$i=1;
echo '
'; $current_page = ($start/$display)+1; if($current_page!=1) { echo 'Previous '; } for($i=1; $i<=$num_pages; $i++) { if($i!=$current_page) { echo ''.$i.' '; } else { echo $i.' '; } } if($current_page!=$num_pages) { echo 'Next'; } echo '
';