<?php include('header.php'); include('options.php'); ?>
<table width="90%" border="0" align="center" cellpadding="2" cellspacing="8" bgcolor="#FFFFFF">
<tr><td><strong>Images</strong></td><tr>
<tr><td width="450px">
<?php
$rowsPerPage = 6;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$result = mysql_query("SELECT * FROM vgalery
 ORDER by galid desc LIMIT $offset, $rowsPerPage") 
or die(mysql_error()); 
while($row=mysql_fetch_array($result))
{
?>
<b>Title: <?php echo $row['gtitle'] ?></b><br />
<img src="<?php echo $config['path']; ?>/minthumb/<?php echo $row['guniver'] ?>"><br />
 


<a href="delimage.php?id=<?php echo $row['galid'] ?>&file=<?php echo $row['guniver'] ?>"><font color="red">Delete <?php $row['gtitle'] ?></font></a><br /><br />

<?php
}
$query   = "SELECT COUNT(usid) AS numrows FROM users";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav  = '';
for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
      $nav .= " $page ";
   }
   else
   {
      $nav .= " <a href=\"$self?page=$page\">$page</a> ";
   } 
}
if ($pageNum > 1)
{
   $page  = $pageNum - 1;
   $prev  = " <a href=\"$self?page=$page\">[Prev]</a> ";
   $first = " <a href=\"$self?page=1\">[First Page]</a> ";
} 
else
{
   $prev  = '&nbsp;';
   $first = '&nbsp;'; 
}
if ($pageNum < $maxPage)
{
   $page = $pageNum + 1;
   $next = " <a href=\"$self?page=$page\">[Next]</a> ";
   $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
} 
else
{
   $next = '&nbsp;'; 
   $last = '&nbsp;'; 
}
echo $first . $prev . $nav . $next . $last;
 
?>
  </td>
 </tr>
</table>