include("Startconnect.php");
$sqldetail = "SELECT * FROM hoteldetail WHERE hotelid='$hotelid';";
$resultdetail = mysql_db_query($database,$sqldetail);
$datadetail = mysql_fetch_array($resultdetail);
$sqlfac = "SELECT * FROM hotelfacilitynew WHERE hotelid='$hotelid';";
$resultfac = mysql_db_query($database,$sqlfac);
$datafac = mysql_fetch_array($resultfac);
$sqlpic = "SELECT * FROM picture WHERE hotelid='$hotelid';";
$resultpic = mysql_db_query($database,$sqlpic);
$datapic = mysql_fetch_array($resultpic);
$sqlmata = "SELECT * FROM matatag WHERE hotelid='$hotelid';";
$resultmata = mysql_db_query($database,$sqlmata);
$datamata = mysql_fetch_array($resultmata);
$sqlrate = "SELECT * FROM ratepricenew where hotelid = '$hotelid' ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultrate = mysql_db_query($database,$sqlrate);
$num_rows_rate=mysql_num_rows($resultrate);
$sqlsdate = "SELECT DATE_FORMAT(startdate,'%d %b %Y') AS startdatefull FROM ratepricenew where hotelid ='$hotelid' ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultsdate = mysql_db_query($database,$sqlsdate);
$sqledate = "SELECT DATE_FORMAT(enddate,'%d %b %Y') AS enddatefull FROM ratepricenew where hotelid = '$hotelid' ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultedate = mysql_db_query($database,$sqledate);
$sqlnumroom ="SELECT roomtype ,COUNT(*) AS numroom FROM ratepricenew WHERE hotelid = '$hotelid' GROUP BY roomtype ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;" ;
$resultnumroom = mysql_db_query($database,$sqlnumroom);
$num_rows_room=mysql_num_rows($resultnumroom);
$sqlnumbed2="SELECT roomtype ,COUNT(DISTINCT bedtype) AS numbed FROM ratepricenew WHERE hotelid ='$hotelid' GROUP BY roomtype ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultnumbed2 = mysql_db_query($database,$sqlnumbed2);
$num_rows_bed2=mysql_num_rows($resultnumbed2);
$sqlnumbed="SELECT roomtype,bedtype ,COUNT(*) AS numbed FROM ratepricenew WHERE hotelid = '$hotelid' GROUP BY roomtype,bedtype ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultnumbed = mysql_db_query($database,$sqlnumbed);
$num_rows_bed=mysql_num_rows($resultnumbed);
?>
• Hotel rates are per room per night, nett, non commissionable, and inclusive of service charge 10% and current applicable Value Added Tax 7%.
• Single room = One person, Twin/Double room = Two persons, Triple room = Three persons, including extra bed.