<html>
<head>
<title>Web management</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-7">
<link rel="stylesheet" href="../styles.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="10">
<table width="700" border="1" cellspacing="0" cellpadding="0" align="center" class="webadmintext" bordercolor="#999999" bgcolor="#FFFFFF">
  <tr> 
    <td bgcolor="#666666" bordercolor="#666666"> 
      <div align="center" class="white">
        <?php 
			$nu_row = '0';
              $zero='0';
			include 'connect.php';
			$sql = "SELECT * FROM photos";
			$result = mysql_query($sql);
			$nu_row = mysql_num_rows($result);
?>
        <?php echo $nu_row  ?>
        PHOTO GALLERY</div>
    </td>
  </tr>
  <tr> 
    <td bgcolor="#FFFFFF" bordercolor="#FFFFFF"> 
      <table width="100%" border="0" cellspacing="1" cellpadding="2" class="webadmintext" bgcolor="#FFFFFF">
        <tr> 
          <td valign="top">ΕΝΟΤΗΤΕΣ</td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
      <?php 
			include 'connect.php';
			$sql = "SELECT * FROM photocategories ORDER BY priority";
			$result = mysql_query($sql);
	while ($myrow=mysql_fetch_array($result)) {
			$id=$myrow['id'];
			$category=$myrow['category'];
			$priority=$myrow['priority'];
?>
      <table width="100%" border="0" cellspacing="1" cellpadding="2" class="webadmintext" bgcolor="#FFFFFF">
        <tr valign="top" bgcolor="#F2F2F2"> 
          <td> 
            <?php 
             $nu_row1 = '0';
              $zero='0';
			include 'connect.php';
			$sql2 = "SELECT * FROM  photos WHERE category_id=$id";
			$result2= mysql_query($sql2);
			$nu_row1 = mysql_num_rows($result2);
?>
            <?php 
	if  ( ( $nu_row1==$zero)) {
	?>
            <?php echo $category ?>
            <?php } else {?>
            <a href="all-photos.php?catid=<?php echo $id?>&cat=<?php echo $category?>" class="webadminlinks"> 
            <?php echo $category ?>
            </a> <b> [ 
            <?php echo $nu_row1  ?>
            ] </b> 
            <?php } ?>
          </td>
        </tr>
      </table>
      <?php			
	}
?>
      <br>
      <?php 
             $nu_row2 = '0';
              $zero='0';
			include 'connect.php';
			$sql3 = "SELECT * FROM  photos WHERE category_id='0' AND room_id='0'";
			$result3= mysql_query($sql3);
			$nu_row2 = mysql_num_rows($result3);
?>
      <?php 
	if  ( ( $nu_row2==$zero)) {
	?>
      <?php } else {?>
</td>
  </tr>
  <tr> 
    <td bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
      <table width="100%" border="0" cellspacing="1" cellpadding="2" class="webadmintext" bgcolor="#FFFFFF">
        <tr valign="top" bgcolor="#F2F2F2"> 
          <td> <a href="all-photos.php?catid=0&cat=PHOTO GALLERY ΚΕΝΤΡΙΚΟ" class="webadminlinks">PHOTO GALLERY ΚΕΝΤΡΙΚΟ</a> <b> [ 
            <?php echo $nu_row2  ?>
            ] </b> </td>
        </tr>
      </table>
      <?php } ?>
      <br>
	        <?php 
             $nu_row3 = '0';
              $zero='0';
			include 'connect.php';
			$sql4 = "SELECT * FROM  photos WHERE room_id > '0'";
			$result4= mysql_query($sql4);
			$nu_row3 = mysql_num_rows($result4);
?>
      <?php 
	if  ( ( $nu_row3==$zero)) {
	?>
      <?php } else {?>
  </td>
  </tr>
  <tr> 
    <td bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
      <table width="100%" border="0" cellspacing="1" cellpadding="2" class="webadmintext" bgcolor="#FFFFFF">
        <tr valign="top" bgcolor="#F2F2F2"> 
          <td> <a href="all-roomsphotos.php?catid=0&cat=PHOTO GALLERY ΔΩΜΑΤΙΩΝ" class="webadminlinks">PHOTO GALLERY ΔΩΜΑΤΙΩΝ</a> <b> [ 
            <?php echo $nu_row3  ?>
            ] </b> </td>
        </tr>
      </table>
      <?php } ?>
    </td>
  </tr>
</table>
<table width="700" border="0" cellspacing="0" cellpadding="4" align="center">
  <tr>
    <td>
      <div align="center"> <a href="javascript:history.go(-1);"><img src="back.gif" alt="πίσω" border="0"></a> 
        &nbsp; <a href="#top"><img src="top.gif" border="0" alt="πάνω"></a> 
      </div>
    </td>
  </tr>
</table>
</body>
</html>
