<?php include ('check.php'); ?>
<?php require_once('Connections/connresort.php'); ?>
<?php
mysql_select_db($database_connresort, $connresort);
$query_rsCalendar = "SELECT * FROM mycalendar WHERE '$now_stamp' BETWEEN start and end";
$rsCalendar = mysql_query($query_rsCalendar, $connresort) or die(mysql_error());
$row_rsCalendar = mysql_fetch_assoc($rsCalendar);
$totalRows_rsCalendar = mysql_num_rows($rsCalendar);
?>

<style type="text/css">
<!--
.style2 {
    color: #9900FF;
    font-weight: bold;
    font-size: 13px;
}
.style3 {font-size: 12px}
.style4 {font-size: 13px}
.style5 {
    color: #FFFFFF;
    font-weight: bold;
}
-->
</style>


<table width="500" height="213"  border="1" cellpadding="0" cellspacing="0" bordercolor="#0000FF">
  <tr>
    <td bgcolor="#0000FF"><div align="center" class="style5">ปฏิทินเหตุการณ์ ของวันที่ <? echo dateThai($now_stamp); ?>มีจำนวน <?php echo $totalRows_rsCalendar ?> เหตุการณ์</div></td>
  </tr>
  <tr>
    <td><?php do {  ?>
      <table width="98%"  border="0" align="center" cellpadding="0" cellspacing="0">
       
        <tr bgcolor="#CCCCCC">
          <td colspan="2"><div align="center" class="style2 style3">
              <div align="left">เหตุการณ์ที่ <?php echo ++$i;?></div>
          </div></td>
        </tr>
        <tr>
          <td width="30%"><div align="right" class="style4">ชื่อเหตุการณ์ : </div></td>
          <td width="70%"><span class="style4"><?php echo $row_rsCalendar['title']; ?></span></td>
        </tr>
        <tr>
          <td valign="top"><div align="right" class="style4">รายละเอียดเหตุการณ์ : </div></td>
          <td><span class="style4">
            <textarea  readonly name="textarea" cols="50" rows="5"><?php echo $row_rsCalendar['description']; ?></textarea>
            </span></td>
        </tr>
        <tr>
          <td><div align="right" class="style4">เริ่มตั่งแต่วันที่ : </div></td>
          <td><span class="style4"><?php echo dateThai($row_rsCalendar['start']); ?> ถึงวันที่ <?php echo dateThai($row_rsCalendar['end']); ?></span></td>
        </tr>
        <tr>
          <td><div align="right" class="style4">ผู้เขียน: </div></td>
          <td><span class="style4"><?php echo $row_rsCalendar['service']; ?></span></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
      </table>
      <?php } while ($row_rsCalendar = mysql_fetch_assoc($rsCalendar)); ?></td>
  </tr>
</table>
<?php
mysql_free_result($rsCalendar);
?>