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);
?>
83/199 Soi Moo Baan Nonggare, Nonggare , Hua Hin , Prachuab Khirikhan , 77110 , Thailand
Telephone:
+66 3253 6999
Facsimile:
The Wora Bura Resort & Spa, Hua Hin is cradled directly on the peaceful beachfront of Hua Hin. Many interesting spots including Kho Takiap and Hua Hin Night Market with its wide range of stalls and shops are within a short drive away. The luxury Wora Bura Resort & Spa offers elegant Thai and European style rooms, and has a restful atmosphere.
• 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.