$location_sql = "select fld_name,fld_id from tbl_location where fld_cityid = '$city_id' order by fld_name asc";
$location_result = mysql_query($location_sql) or die ('Invalid query location: ' . mysql_error());
if(mysql_num_rows($location_result)>0)
{
?>
}
?>
$hotel_sql5 = "select fld_hotelname,fld_id,fld_seourl from tbl_hotel_info where fld_city RLIKE '[[:<:]]".$city_id."[[:>:]]' and fld_starrating in(8,9) order by fld_hotelname asc limit 0,8";
$hotel_result5 = mysql_query($hotel_sql5) or die ('Invalid query hotel: ' . mysql_error());
if(mysql_num_rows($hotel_result5)>0)
{
?>
}
?>
$hotel_sql4 = "select fld_hotelname,fld_id,fld_seourl from tbl_hotel_info where fld_city RLIKE '[[:<:]]".$city_id."[[:>:]]' and fld_starrating in(6,7) order by fld_hotelname asc limit 0,8";
$hotel_result4 = mysql_query($hotel_sql4) or die ('Invalid query: ' . mysql_error());
if(mysql_num_rows($hotel_result4)>0)
{
?>
}
?>
$hotel_sql3 = "select fld_hotelname,fld_id,fld_seourl from tbl_hotel_info where fld_city RLIKE '[[:<:]]".$city_id."[[:>:]]' and fld_starrating in(4,5) order by fld_hotelname asc limit 0,8";
$hotel_result3 = mysql_query($hotel_sql3) or die ('Invalid query: ' . mysql_error());
if(mysql_num_rows($hotel_result3)>0)
{
?>
}
?>
$hotel_sql2 = "select fld_hotelname,fld_id,fld_seourl from tbl_hotel_info where fld_city RLIKE '[[:<:]]".$city_id."[[:>:]]' and fld_starrating in(2,3) order by fld_hotelname asc limit 0,8";
$hotel_result2 = mysql_query($hotel_sql2) or die ('Invalid query: ' . mysql_error());
if(mysql_num_rows($hotel_result2)>0)
{
?>
}
?>
$hotel_sql1 = "select fld_hotelname,fld_id,fld_seourl from tbl_hotel_info where fld_city RLIKE '[[:<:]]".$city_id."[[:>:]]' and fld_starrating <=1 order by fld_hotelname asc limit 0,8";
$hotel_result1 = mysql_query($hotel_sql1) or die ('Invalid query: ' . mysql_error());
if(mysql_num_rows($hotel_result1)>0)
{
?>
}
?>
include("include/book_reason.php");
?>
$city_sql = "select fld_details from tbl_attrac_citywise where fld_cityid = '$city_id'";
$city_result = mysql_query($city_sql) or die ('Invalid query: ' . mysql_error());
$city_row=mysql_fetch_array($city_result);
$description=str_replace("/userfiles/image/","http://myhoteltrip.com/userfiles/image/",$city_row['fld_details']);
if($description!='')
{
?>
}
?>
Locations in Hyderabad. Find your Hotels by Locations
while($location_row=mysql_fetch_array($location_result))
{
$hotel_sql = "select fld_id from tbl_hotel_info where ".$location_row['fld_id']." IN (fld_location) and fld_status=1 ";
$hotel_result = mysql_query($hotel_sql) or die ('Invalid query: ' . mysql_error());
$count=mysql_num_rows($hotel_result);
?>
}
$hotel_sql = "select fld_id from tbl_hotel_info where fld_location='' and fld_status=1 and $city_id in (fld_city) ";
$hotel_result = mysql_query($hotel_sql) or die ('Invalid query: ' . mysql_error());
$count=mysql_num_rows($hotel_result);
?>
Map of Hyderabad
Top 5 Star Hotels in Hyderabad
Top 4 Star Hotels in Hyderabad
Top 3 Star Hotels in Hyderabad
Top 2 Star Hotels in Hyderabad
Top Budget Hotels in Hyderabad
About Hyderabad
$hotel_sql = "select fld_hotelname,fld_logo,fld_location,fld_id,fld_starrating,fld_seourl from tbl_hotel_info where fld_city RLIKE '[[:<:]]".$city_id."[[:>:]]' order by fld_ranking asc limit 0,20";
$hotel_result = mysql_query($hotel_sql) or die ('Invalid query: ' . mysql_error());
if(mysql_num_rows($hotel_result))
{
?>
while($hotel_row=mysql_fetch_array($hotel_result))
{
if($hotel_row['fld_starrating']==4 || $hotel_row['fld_starrating']==5)
{
$ctr=3;
}
elseif($hotel_row['fld_starrating']==6 || $hotel_row['fld_starrating']==7)
{
$ctr=4;
}
elseif($hotel_row['fld_starrating']==8 || $hotel_row['fld_starrating']==9)
{
$ctr=5;
}
elseif($hotel_row['fld_starrating']==3)
{
$ctr='2';
}
elseif($hotel_row['fld_starrating']==2)
{
$ctr='1';
}
else
{
$ctr='0';
//$ctrs[]=($hotel_row2['fld_starrating'] - 1);
}
$alias=trim($hotel_row['fld_seourl']);
?>
}
}
else
{
?>
}
?>
Recommended Hotels in Hyderabad, India
# echo($hotel_row['fld_starrating']);
for($i=1;$i<=$ctr;$i++)
{
?>
}
if ($hotel_row['fld_starrating'] ==5 || $hotel_row['fld_starrating']==7 || $hotel_row['fld_starrating']==9)
{
?>
}
?>
$sql = "select fld_name from tbl_location where fld_id IN ('".$hotel_row['fld_location']."')";
$result = mysql_query($sql) or die ('Invalid query: ' . mysql_error());
$row=mysql_fetch_array($result);
if($row['fld_name']!='')
{
?>
Hotel Area :
}
$info_sql = "select fld_description from tbl_hotel_contents where fld_hotelid ='".$hotel_row['fld_id']."' and fld_svid=1";
$info_result = mysql_query($info_sql) or die ('Invalid query: ' . mysql_error());
$info_row=mysql_fetch_array($info_result);
$description = strip_tags($info_row['fld_description']);
?>
echo(substr(stripcslashes($description),0,150));
echo (strlen($description)==0?'':'......');
?>
Recommended Hotels in Hyderabad, India
- HotelsGDS.com provides you all the information and services related to your Group & holiday planning. Our Expert will guide you for your every need & organize group movement in an efficient way. It means you will save time, money & energy. Our Guide staffs are multi lingual, energetic & always curious to help you. You will feel as you are in your native place & enjoy your trip, holidays & weekend breaks as much as you think. We have the Best Hotel Rates, Best Holiday Packages / Tour Packages for Hyderabad, India. Please send us inquiry so that we can send you the Best Hotel Rates, Best Holiday Packages.