All pastes #187423 Raw Edit

Miscellany

public php v1 · immutable
·published 2006-10-01 02:39 UTC
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>';