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);
?>
854/2, Burirom Road , Cha Am , Phetchaburi , , Thailand
Telephone:
Facsimile:
Tipviman Resort & Spa, Cha Am located in the area of Cha-am. Just 2 hours easy drive south of Bangkok. Guests are made to feel totally at home as soon as they arrive. Opened in 1992, Golden Sands Hotel has 226 deluxe rooms with panoramic ocean views and loads of amenities.
Tipviman Resort & Spa, Cha-Am, is located on an unspoiled beach, overlooking gulf of Thailand. It is just 2 hrs drive from Bangkok, 20 minutes to the charming town of Hua-Hin and 30 minutes from Hua-Hin railway station.
• 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.