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);
?>
Central Hua Hin Village Hua Hin in Prachuab-Khirikhan Thailand
Central Hua Hin Village, Hua Hin is the ideal place to experience Thailand s original beach destination. The Central Hua Hin Village hotel is set in its own lush tropical garden right on the shores of the Gulf of Siam. It is distinctly Thai village style, in a garden setting complete with fountains, rock and ponds leading down to the sea.
• 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.