rendered paste body$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 '<br /><p class="portfolio">'; $current_page = ($start/$display)+1; if($current_page!=1) { echo '<a href="http://'.$_SERVER['HTTP_HOST'].'?p=portfolio&nav=recent&pid='.$id.'&s='.($start-$display).'" class="portfolio">Previous</a> '; } for($i=1; $i<=$num_pages; $i++) { if($i!=$current_page) { echo '<a href="http://'.$_SERVER['HTTP_HOST'].'?p=portfolio&nav=recent&pid='.$id.'&s='.(($display*($i-1))).'" class="portfolio">'.$i.'</a> '; } else { echo $i.' '; } } if($current_page!=$num_pages) { echo '<a href="http://'.$_SERVER['HTTP_HOST'].'?p=portfolio&nav=recent&pid='.$id.'&s='.($start+$display).'" class="portfolio">Next</a>'; } echo '</p>';