<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 RESERVATIONS ORDER BY id";
			$result = mysql_query($sql);
			$nu_row = mysql_num_rows($result);
?>
        <?php echo $nu_row  ?>
        REQUESTS</div>
    </td>
  </tr>
  <tr> 
    <td bgcolor="#FFFFFF" bordercolor="#FFFFFF"> 
      <table width="100%" border="0" cellspacing="1" cellpadding="2" class="webadmintext" bgcolor="#FFFFFF">
        <tr valign="top"> 
          <td>ΟΝΟΜΑ - ΣΤΟΙΧΕΙΑ</td>
          <td width="250">ΑΙΤΗΣΗ</td>
          <td width="140">ΠΡΟΕΛΕΥΣΗ</td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
      <?php 
			include 'connect.php';
			$sql = "SELECT * FROM RESERVATIONS ORDER BY id";
			$result = mysql_query($sql);
	while ($myrow=mysql_fetch_array($result)) {
			$ID=$myrow['ID'];
			$HOLIDAY_ID=$myrow['HOLIDAY_ID'];
			$date=$myrow['AUTODATE'];
			$NAME=$myrow['NAME'];
			$ADDRESS=$myrow['ADDRESS'];
			$CITY=$myrow['CITY'];
			$COUNTRY=$myrow['COUNTRY'];
			$PHONE=$myrow['PHONE'];
			$FAX=$myrow['FAX'];
			$EMAIL=$myrow['EMAIL'];
			$ROOM_TYPE=$myrow['ROOM_TYPE'];
			$ARRIVAL_DATE=$myrow['ARRIVAL_DATE'];
			$DEPARTURE_DATE=$myrow['DEPARTURE_DATE'];
			$ADULTS=$myrow['ADULTS'];
			$CHILDREN=$myrow['CHILDREN'];
			$PAYMENT=$myrow['PAYMENT'];
			$SUBJECT=$myrow['SUBJECT'];
			$COMMENTS=$myrow['COMMENTS'];
			$SOURCE=$myrow['SOURCE'];
			$SOURCE_URL=$myrow['SOURCE_URL'];
?>
      <table width="100%" border="0" cellspacing="1" cellpadding="2" class="webadmintext" bgcolor="#FFFFFF">
        <tr valign="top" bgcolor="#F2F2F2"> 
          <td> <b> 
            <?php echo $NAME  ?>
            <br>
            <?php $s_year = substr("$date", 0, 4);   ?>
            <?php $s_month = substr("$date", 5, 2);   ?>
            <?php $s_day = substr("$date", 8, 2);   ?>
            <?php  echo $s_day ?>
            . 
            <?php  echo $s_month ?>
            . 
            <?php  echo $s_year ?>
            </b> <br>
            <?php echo $ADDRESS ?>
            - 
            <?php echo $CITY ?>
            - 
            <?php echo $COUNTRY ?>
            <br>
            Tel. 
            <?php echo $PHONE ?>
            - Fax 
            <?php echo $FAX ?>
            <br>
            <?php echo $email ?>
          </td>
          <td width="250"> 
            <?php echo $ROOM_TYPE  ?>
            <br>
            <?php echo $ARRIVAL_DATE ?>
            - 
            <?php echo $DEPARTURE_DATE ?>
            <br>
            Adults 
            <?php echo $ADULTS ?>
            - Children 
            <?php echo $CHILDREN ?>
            <br>
            Payment 
            <?php echo $PAYMENT ?>
            <br>
            __________________<br>
            Comments <br>
            <?php echo $SUBJECT ?>
            <br>
            <?php echo $COMMENTS ?>
          </td>
          <td width="140"> 
            <?php echo $SOURCE  ?>
            <br>
            <a href="http://www.<?php echo $SOURCE_URL   ?>" class="webadminlinks" target="_blank"> 
            URL </a> </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>
