$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 '

';