All pastes #719707 Raw Edit

Stuff

public php v1 · immutable
#719707 ·published 2007-09-29 15:15 UTC
rendered paste body
<?phpif (isset($_GET['pageno'])) {   $pageno = $_GET['pageno'];} else {   $pageno = 1;} // if$query = "SELECT count(*) FROM files";$result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);$query_data = mysql_fetch_row($result);$numrows = $query_data[0];$rows_per_page = 6;$lastpage = ceil($numrows/$rows_per_page);$pageno = (int)$pageno;if ($pageno < 1) {   $pageno = 1;} elseif ($pageno > $lastpage) {   $pageno = $lastpage;} // if$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;$query = mysql_query("select * from files $limit") or die(mysql_error());$count = 0;while ($sql = mysql_fetch_array($query)){	$name = $sql['name'];	$description = $sql['description'];	$thumbnail = $sql['thumbnail'];	$file = $sql['file'];	$id = $sql['id'];			$count++;	if ($count == 1){		echo '<ul>';	}	echo '<li>						<div class="box">							<a href="#" title="MotherLoad"><img src="images/motherload.jpg" alt="MotherLoad" title="MotherLoad" /></a>							<h3><a href="viewgame.php?id='.$id.'" title="MotherLoad">'.$name.'</a></h3>							<p>'.$description.'</p>						</div>					</li>';	if ($count == 3){		echo '</ul>';		$count = 0;	}}if ($count > 0){	echo '</ul>';}if ($pageno == 1) {   echo " FIRST PREV ";} else {   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'>FIRST</a> ";   $prevpage = $pageno-1;   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'>PREV</a> ";} // ifecho " ( Page $pageno of $lastpage ) ";if ($pageno == $lastpage) {   echo " NEXT LAST ";} else {   $nextpage = $pageno+1;   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>NEXT</a> ";   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>LAST</a> ";} // if?>