<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("tcems", $con);
$ids=$_POST["ids"];
$Id1=$_POST["AccomIden"];
$Id=$_POST["NameAccom"];
$name = $_POST["AccomName"];
$pword= $_POST["AccomPword"];
$rooms = $_POST["NumRooms"];
$class = $_POST["classification"];
$type = $_POST["type"];
$old = $_POST["oldpword"];
if($_POST["adminPassword"]==$old){

    if($ids==$Id1){
  $sql="UPDATE tblnewaccom set AccomIden='$Id1', NameAccom='$name', NumRooms='$rooms',
        Password='$pword',Classification='$class',Type='$type' where AccomIden='$ids'";

    if (!mysql_query($sql,$con))
    {
        die('Error: ' . mysql_error());
    }
    else
    {
      echo "

      <div id=all>
    <fieldset style=text-align:center>
  <table align=center class=prompt>
  <tr>
  <td class=imggoback rowspan=2>&nbsp</td>
  <td class=norecord>
    SUCCESSFULLY UPDATED!
  </td>
  </tr>

  <tr>
  <td class=goback>
  <a class=goback href='header.php'>Go Back</a>
  </td>
  </tr>
  </table>
  </fieldset>
  </div>

      ";
      }

    }

else{
$query="SELECT * FROM tblnewaccom where AccomIden='$_POST[AccomIden]'";
$result = mysql_query($query);
 $flag=0;
 while ($row=mysql_fetch_array($result))
{
 $flag=$flag+1;
}

if($flag==0){
$sql="UPDATE tblnewaccom set AccomIden='$Id1', NameAccom='$name', NumRooms='$rooms',
        AccomPword='$pword',Classification='$class',Type='$type' where AccomIden='$ids'";

    if (!mysql_query($sql,$con))
    {
        die('Error: ' . mysql_error());
    }
    else
    {
        include ("AddRoom.php");     //if all boxes filled
    }

}
else
{
    echo "".$ids."";
    echo "".$Id1."";
  //include ("Header.php");  //flag is not equal to zero or accom id existing
  }
}
}
else{
  header('Location:EditAccomh.php');    //wrong admin password
}
mysql_close($con);


?>