All pastes #89426 Raw Edit

Miscellany

public text v1 · immutable
#89426 ·published 2006-07-16 06:53 UTC
rendered paste body
<?PHP
 session_start();
 require("access.php");
 ?>

<?php include("top2.php"); ?>

<?php
$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))
{


$query = mysql_query("select * from gallery WHERE active = '1' ") or die(mysql_error());
while($data = mysql_fetch_array($query))
{


?>


<center>
<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>
</center>
<?PHP
};
?>



<?php include("bottom2.php"); ?>