<?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 gerbitz_id = '".$_SESSION[UserName]."'") 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 gerbitz_id = '".$_SESSION[UserName]."' $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 )) { ?><br><br><hr><center>Want to upload images? click <a href="gallery_upload.php">here</a> </center><hr><br><br><table width="433" border="0"> <tr> <td width="89"><div align="center"><strong>Photo Name:</strong></div></td> <td colspan="4"><?=$data['short_title']?> </td> </tr> <tr> <td><div align="center"><strong>Title:</strong></div></td> <td colspan="4"><?=$data['title']?> </td> </tr> <tr> <td height="154"><div align="center"><strong>Image: </strong></div></td> <td colspan="4"><img src="<?=$data['image_loc']?> " width="300" height="200"></td> </tr> <tr> <td height="62"><div align="center"><strong>Description:</strong></div></td> <td colspan="4"><?=$data['description']?> </td> </tr> <tr> <td> </td> <td width="85"><?phpif ($data['active'] == '1'){ echo '<form method="post" action="gallery_de-activate.php?gallery_id=' . $data['gallery_id'] . '">'; echo '<input name="De-Activate" type="submit" id="De-Activate" value="De-Activate">'; echo '</form>';}else{ echo '<form method="post" action="gallery_activate.php?gallery_id=' . $data['gallery_id'] . '">'; echo '<input name="Activate" type="submit" id="Activate" value="Activate">'; echo '</form>';}?></td> <td width="84"><form method="post" action="gallery_delete.php?gallery_id=<?=$data['gallery_id']?>"><input name="Delete" type="submit" id="Delete" value="Delete"></form></td> <td width="59"><form method="post" action="gallery_edit.php?gallery_id=<?=$data['gallery_id']?>"><input name="Edit" type="submit" id="Edit" value="Edit"></form></td> </tr></table><?PHP};?><br><br><hr><center>Want to upload images? click <a href="gallery_upload.php">here</a> </center><hr><br><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"); ?>