<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Web management</title>
<link rel="stylesheet" href="styles.css" type="text/css">
<?php include 'codes.php';?>
</head>
<body text="#000000" style="margin:0">
<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>
    
<div><img src="img/frame-list.png" width="180" height="37" alt=""></div>
<div class="frame">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="text">
  <tr>
    <td align="center"><div class="titles">
      <?php
			$sql = "SELECT * FROM rooms";
			$result = mysql_query($sql);
			$nu_row = mysql_num_rows($result);
?>
      <?php echo $nu_row  ?></div></td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="1" cellpadding="4" class="text">
        <tr> 
          <td width="50"><img src="img/ic3.png" alt=""></td>
          <td><div class="titles">ΔΩΜΑΤΙΑ - SITE</div></td>
          <td width="370">&nbsp;</td>
          <td width="70" align="center">&nbsp;</td>
          <td width="70" align="center">&nbsp;</td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td>
	<?php
			$sql = "SELECT * FROM rooms WHERE publisha='yes' AND publish='yes' ORDER BY priority";
			$result = mysql_query($sql);
        	while ($myrow=mysql_fetch_array($result)) {
			$id=$myrow['id'];
	       $name=$myrow['name'];
		   $image=$myrow['image'];
		   $publish=$myrow['publish'];
		   $publisha=$myrow['publisha'];
		   $publishb=$myrow['publishb'];
		   $priority=$myrow['priority'];
?>
	
</td>
  </tr>
  <tr>
    <td>
      <?php include 'roomin.php';?>
      </td>
  </tr>
  <tr>
    <td>
      <?php } ?></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="1" cellpadding="4" class="text">
        <tr> 
          <td width="50"><img src="img/ic6.png" alt=""></td>
          <td width="150"><div class="titles">ΤΙΜΟΚΑΤΑΛΟΓΟΣ</div></td>
          <td bgcolor="#F2F2F2">
            
            <table width="100%" border="0" cellspacing="1" cellpadding="0">
              <tr>
                <?php
			$sql7 = "SELECT * FROM seasons ORDER BY id";
			$result7 = mysql_query($sql7);
	while ($myrow=mysql_fetch_array($result7)) {
			$seasonid=$myrow['id'];
			$season=$myrow['season'];
			$date1=$myrow['date1'];
			$date2=$myrow['date2'];
?>
                <td valign="top">
                  <div style="width:100px" align="center"> <a href="edit-season.php?id=<?php echo $seasonid?>" class="links"><?php echo $season ?></a> <br>
                    <?php echo $date1 ?> <br>
                    <?php echo $date2 ?></div>
                  </td>
                
                <?php } ?>    
                </tr>
              </table>
            
          </td>
          <td width="260">&nbsp;</td>
          </tr>
      </table>
      
    </td>
  </tr>
  <tr>
    <td><?php
			$sql1 = "SELECT * FROM rooms WHERE publishb='yes' AND publish='yes' ORDER BY priority";
			$result1 = mysql_query($sql1);
        	while ($myrow=mysql_fetch_array($result1)) {
			$id=$myrow['id'];
	       $name=$myrow['name'];
		   $image=$myrow['image'];
		   $publish=$myrow['publish'];
		   $publisha=$myrow['publisha'];
		   $publishb=$myrow['publishb'];
		   $priority=$myrow['priority'];
?></td>
  </tr>
  <tr>
    <td><?php include 'roominb.php';?></td>
  </tr>
  <tr>
    <td><?php } ?></td>
  </tr>
  <tr>
    <td><hr></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>
     <?php 
			$sql = "SELECT * FROM rooms WHERE publish='no'";
			$result = mysql_query($sql);
			$nu_row = mysql_num_rows($result);
?>
                  <?php 
	if  ( ( $nu_row>0)) {
	?>
    </td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="1" cellpadding="4" class="text">
      <tr>
        <td width="50"><img src="img/ic7.png" alt=""></td>
        <td><div class="titles">ΜΗ ΔΗΜΟΣΙΕΥΜΕΝΑ</div></td>
        <td width="370">&nbsp;</td>
        <td width="70" align="center">&nbsp;</td>
        <td width="70" align="center">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><?php
			$sql10 = "SELECT * FROM rooms WHERE publish='no' ORDER BY priority";
			$result10 = mysql_query($sql10);
        	while ($myrow=mysql_fetch_array($result10)) {
			$id=$myrow['id'];
	       $name=$myrow['name'];
		   $image=$myrow['image'];
		   $publish=$myrow['publish'];
		   $publisha=$myrow['publisha'];
		   $publishb=$myrow['publishb'];
		   $priority=$myrow['priority'];
?></td>
  </tr>
  <tr>
    <td><?php include 'roomin.php';?></td>
  </tr>
  <tr>
    <td>
	<?php } ?>
    <?php } ?> 
    </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  </table>
</div>
</td>
  </tr>
</table>
<?php include 'menudown.php';?>
</body>
</html>
