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?>