<?PHP session_start(); require("access.php");include("top2.php"); //This checks to see if there is a page number. If not, it will set it to page 1 if (!(isset($pagenum))) { $pagenum = 1; } //Here we count the number of results //Edit $data to be your query $data = mysql_query("SELECT * FROM gallery WHERE active='1'") or die(mysql_error()); $rows = mysql_num_rows($data); //This is the number of results displayed per page $page_rows = 3; //This tells us the page number of our last page $last = ceil($rows/$page_rows); //this makes sure the page number isn't below one, or more than our maximum pages if ($pagenum < 1) { $pagenum = 1; } elseif ($pagenum > $last) { $pagenum = $last; } //This sets range that we will display in our query $max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;echo "<CENTER>";// THE PAGE MENUS //if ($pagenum == 1) {} else{echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";echo " ";$previous = $pagenum-1;echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";} //just a spacerecho " ---- ";//This does the same as above, only checking if we are on the last page, and then generating the Next and Last linksif ($pagenum == $last) {} else {$next = $pagenum+1;echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";echo " ";echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> "} // END OF PAGE MENUS// echo "<BR><BR>";//This is your query again, the same one... the only difference is we add $max into it$data_p = mysql_query("SELECT * FROM gallery WHERE active='1' $max") or die(mysql_error()); echo " -- Displaying Page $pagenum of $last -- <p>";//This is where you display your query resultswhile($info = mysql_fetch_array( $data_p )) { ?><table width="113" border="0"> <tr> <td width="107"><div align="center"><a href="gallery_view.php?gallery_id=<?=$info['gallery_id']?>"> <img src="<?=$info['image_loc']?>" width="75" height="75"></a></div></td> </tr> <tr> <td><div align="center"> <?=$info['owner']?> </div> <div align="center"></div> <div align="center"></div></td> </tr> <tr> <td><div align="center"><a href="gallery_view.php?gallery_id=<?=$info['gallery_id']?>">VIEW IMAGE</a></div></td> </tr></table><br><?PHP} // This shows the user what page they are on, and the total number of pagesecho " -- Displaying Page $pagenum of $last -- <p>";// THE PAGE MENUS //if ($pagenum == 1) {} else{echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";echo " ";$previous = $pagenum-1;echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";} //just a spacerecho " ---- ";//This does the same as above, only checking if we are on the last page, and then generating the Next and Last linksif ($pagenum == $last) {} else {$next = $pagenum+1;echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";echo " ";echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";} // END OF PAGE MENUS//echo "</CENTER>";include("bottom2.php"); ?>