Miscellany

<?PHP session_start(); require("access.php"); ?><?php include("top2.php"); ?><?phpMySQL's COUNT() function. $result = mysql_query("SELECT COUNT(*) AS total_entries FROM gallery WHERE active ='1'") or die(mysql_error()); $row = mysql_fetch_row($result); $total_entries = $row[0]; $entries_per_page = 5; if(isset($_GET['page_number'])) { $page_number = $_GET['page_number']; } else { $page_number = 1; } $total_pages = ceil($total_entries / $entries_per_page); $offset = ($page_number - 1) * $entries_per_page; $result = mysql_query("SELECT * FROM gallery WHERE active= '1'  LIMIT $offset, $entries_per_page") or die(mysql_error()); while($obj = mysql_fetch_object($result)){?><a href="gallery_view.php?gallery_id=<?=$data['gallery_id']?>"> <img src="<?=$data['image_loc']?>" width="75" height="75"></a><BR><?=$data['gallery_id']?><BR><BR><?PHP};?><?PHPfor($i = 1; $i <= $total_pages; $i++) { if($i == $page_number) { // This is the current page. Don't make it a link. print "$i "; } else { // This is not the current page. Make it a link. print " <a href="products.php?page_number=$i">$i</a> "; } } ?><?php include("bottom2.php"); ?>