| |
Sorry ! Unable To Connect To The Server.
Please Try Again !!! ";
print "Error performing query : " . mysql_error() . " ";
exit();
}
mysql_select_db("$vMySQLDatabase", $conn);
if (! @mysql_select_db("hodindia") ){
print "
Sorry ! Unable To Locate The Database At This Time.
Please Try Again !!! ";
print "Error performing query : " . mysql_error() . " ";
mysql_close($conn);
exit();
}
if($v_hotel_group == ""){
$Result = "";
$Result = "
";
$Result .= "";
$Result .="";
$Result .="| ";
$Result .="Hotel Group in India";
$Result .=" | ";
$Result .=" ";
$Result .=" ";
print $Result;
$Result = "";
// execute query
$QueryChain = "SELECT H_Chain_Id, H_Chain_Name FROM Hotel_Chain_Mast Where H_Chain_Status = 't' Order By H_Chain_Name";
$ResultChain = mysql_query($QueryChain, $conn);
$NoOfRecord = mysql_num_rows($ResultChain);
$Result .= "";
$Result .="";
$Result .= "";
$Result .="
";
while($RecordChain = mysql_fetch_assoc($ResultChain)){
$v_class_name = $RecordChain["H_Chain_Name"];
$v_chain_id = $RecordChain["H_Chain_Id"];
// search again hotels in the city
$QueryHotel = "SELECT H_Id FROM Hotel_Mast Where H_Chain_Id = $v_chain_id AND H_Status = 't' ";
$ResultHotel = mysql_query($QueryHotel, $conn);
$no_of_hotels = mysql_num_rows($ResultHotel);
if ($no_of_hotels > 0) {
$v_class_name=ereg_replace(' ', '_', $v_class_name);
$Result .= " ";
$v_class_name=ereg_replace('_', ' ', $v_class_name);
$Result .= $v_class_name;
$Result .= "";
$Result .= "
";
}// end if - no_of_hotels
}//end while
$Result .="";
$Result .= " | ";
$Result .= " ";
$Result .=" ";
$Result .= "
";
$Result .= "
";
print $Result;
}//
else{
$v_hotel_group = ucwords($v_hotel_group);
$QueryChain = "SELECT H_Chain_Id FROM Hotel_Chain_Mast Where H_Chain_Name = '$v_hotel_group'";
$ResultChain = mysql_query($QueryChain, $conn);
$RecordChain = mysql_fetch_assoc($ResultChain);
$v_chain_id = $RecordChain["H_Chain_Id"];
//print "v_class_id = $v_class_id";
$QueryCity = "SELECT City_Id, City_Name FROM City_Mast Order By City_Name";
$ResultCity = mysql_query($QueryCity, $conn);
//$RecordCity = mysql_fetch_assoc($ResultCity);
//print "v_city_id = $v_city_id";
$Result = "";
$Result .= "
";
$Result .= "";
$Result .= "";
$Result .= " ";
print $Result;
$Result = "";
$Result .= "";
$Result .= "
";
while($RecordCity = mysql_fetch_assoc($ResultCity)){
$v_city_id = $RecordCity["City_Id"];
$v_city_name = $RecordCity["City_Name"];
// search again hotels in the city
$QueryHotel = "SELECT H_Login, H_Name FROM Hotel_Mast Where City_Id = $v_city_id And H_Chain_Id = $v_chain_id AND H_Status = 't'";
$ResultHotel = mysql_query($QueryHotel, $conn);
$no_of_ctg_hotels = mysql_num_rows($ResultHotel);
if ($no_of_ctg_hotels != 0){
$Result .= "| ";
$Result .= "";
$Result .= "";
$Result .= $RecordCity["City_Name"];
$Result .= "";
$Result .= "";
$Result .= " [";
$Result .= $no_of_ctg_hotels;
$Result .= "]";
$Result .= " | ";
$Result .= "";
while($RecordHotel = mysql_fetch_assoc($ResultHotel)){
$v_hotel_login = $RecordHotel["H_Login"];
$Result .= " ";
$Result .= "";
$Result .= "";
$Result .= trim($RecordHotel["H_Name"]);
$Result .= "
";
}//end inner while
$Result .= " | ";
//$Result .= "$v_ctg_id
";
}
}//end while
$Result .= " ";
$Result .= "
";
$Result .= "
";
print $Result;
}
mysql_close($conn);
?>
|
