0) while($row = mysql_fetch_row($result)) { $pagetitle = "". $row[1] ." Hotels | Book Cheap ". $row[1] ." Hotels"; $seokey = "Cheap ". $row[1] ." Hotels, Book ". $row[1] ." Hotels"; $seodesc= "Book your ". $row[1] ." Hotels and save money with Egypt Holidays. Read Hotel Reviews on ". $row[1] .". Compare prices on ". $row[1] ." Holidays."; } include ("headerhotel.php"); echo "
"; include ("includes/resortmenu.php"); echo "
"; include ("includes/menu.php"); echo "
"; $query = "SELECT * FROM le_resorts WHERE resortid = '$resortid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo " Egypt Holidays > ". $row[1] ." Hotels "; } $query = "SELECT * FROM le_resorts WHERE resortid = '$resortid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo ""; echo ""; echo ""; echo "

". $row[2] ."
"; } echo "
"; $query = "SELECT r.resortid, r.resort, h.hotelid, h.resortid, h.hotel, IF(CHAR_LENGTH(h.hoteldes)>150,RPAD(LEFT(h.hoteldes,150),153,'.'),h.hoteldes), h.reviewurl, h.hotelrating, h.hoteladd, h.linkyoutravel, h.linkhh, h.linkhayes, h.linkolympic, h.linkhilton, h.linkcosmos, h.linkthomson, h.linkmytravel, h.linkalpha, h.linkmedlife, h.linkxcape, h.linkpeltours, h.linkjmc, h.linkportland, h.linkkuoni, h.linksov, h.linkh4u, h.linkargo FROM le_resorts r, le_hotels h WHERE h.resortid = r.resortid AND r.resortid = '$resortid' ORDER BY h.hotel ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo "
". $row[4] ." \"".str_replace("
". $row[5] . " more

"; } echo "

"; echo "
"; include ("footer.php"); ?>