<?php
$con=mysql_connect("localhost", "root", "");
if(!$con)
{
  die('Could not connect:'.mysql_error());
}
mysql_select_db("tcems", $con);

$query="update tblrooms set
Available='available' where Accom='$_POST[AccomId]' and roomnumber='$_POST[RoomNum]'";
mysql_query($query);

include("header.php");

    echo"<script type='text/javascript'>alert('Guest CHECKED OUT.');</script>

    <html>
  <head>
    <link rel=STYLESHEET type=text/css href=css/style.css />
  </head>
  <body>
  <table align=center class=prompt>
  <tr>
  <td class=imggoback>&nbsp</td>
  <td class=goback>
  <a class=goback href='main.php'>Go Back</a>
  </td>
  </tr>
  </table>
  </body>
  </html>

    .";
?>