include( "../connectdbpr2.php" );
mysql_connect($ServerName, $UserName, $UserPassword ) || UhOh("Can't Connect to Database: ".mysql_error());
mysql_select_db($DataBaseName);
Conn2DB();
$query = "select * from destination3 where left(des_code,2)='$HID'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$mcity = $row["destinations"];
$cur = $_GET["cur"];
switch ($cur)
{
case "":
$query = "SELECT * FROM currency where cur LIKE 'USD'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$unitrate = $row["des"];
$vrates = $row["rates"];
break;
default:
$query = "SELECT * FROM currency where cur LIKE '$cur'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$cur = $row["cur"];
$unitrate = $row["des"];
$vrates = $row["rates"];
}
Conn2DB2();
$query = "SELECT country_code, city_code, city FROM tbp_citycode where city_code='$city_code'" ;
$result1 = mysql_query($query);
$row = mysql_fetch_array($result1);
$city_name = $row["city"];
$country_code = $row["country_code"];
$query = "SELECT * FROM tbp_countrycode where country_code='$country_code'" ;
$result1 = mysql_query($query);
$row = mysql_fetch_array($result1);
$urlcountry1 = $row["urlcountry1"];
$region = $row["region"];
$url_region = $row["url_region"];
$query = "select * from new_hoteldata where city_name='$city_name'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$country_name = $row["country_name"];
?>
List of Hotels Page 2
lswglpngizqcfrqlbgzyxmxykyodgxj
