150,RPAD(LEFT(h.hoteldes,150),150,'.'),h.hoteldes),redirecturl FROM le_resorts r, le_hotels h WHERE h.resortid = r.resortid AND r.resortid = '$resortid' AND h.hotelid = '$hotelid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { if(!empty($row[5])) { header("HTTP/1.1 301 Moved Permanently"); header("location:".$row[5]); exit(); } $pagetitle = "". $row[3] .", ". $row[1] .", Egypt | Egypt Holidays"; $seokey = "". $row[3] .",". $row[1] .",egypt"; $seodesc = "Book ". $row[3] .", ". $row[1] ." online with Egypt Holidays. Read or add your hotel reviews of the ". $row[3] .""; $canon = "http://www.luxuryegypt.co.uk/". $row[2] ."-".str_replace(" ","-",$row[3] )."-".str_replace(" ","-",$row[1] )."-Egypt-". $row[0] .".html"; $title = "". $row[3] .", ". $row[1] .""; $desc = "". $row[4] .""; $url = "http://www.luxuryegypt.co.uk/". $row[2] ."-".str_replace(" ","-",$row[3] )."-".str_replace(" ","-",$row[1] )."-Egypt-". $row[0] .".html"; $type = "hotel"; $region = "". $row[1] .""; $country = "Egypt"; $image = "http://www.luxuryegypt.co.uk/images/hotels/". $row[2] . ".jpg"; $site_name = "Egypt Holidays"; } include ("headerog.php"); echo "
"; include ("includes/resortmenu.php"); echo "
"; include ("includes/menu.php"); echo "
"; $query = "SELECT * FROM le_resorts r, le_hotels h WHERE h.resortid = r.resortid AND r.resortid = '$resortid' AND h.hotelid = '$hotelid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) { while($row = mysql_fetch_row($result)) { echo " Egypt Holidays > ". $row[1] ." Hotels > ". $row[7] ." "; } echo "
"; } echo "
"; echo ""; echo "
"; $query = "SELECT r.resortid, r.resort, h.hotelid, h.resortid, h.hotel, 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, h.search FROM le_resorts r, le_hotels h WHERE h.resortid = r.resortid AND r.resortid = '$resortid' AND h.hotelid = '$hotelid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; } else { echo "
There are currently No Reviews for this hotel.
Why not be the first to add yours? - Add My Review
"; } $query = "SELECT r.resortid, r.resort, h.hotelid, h.resortid, h.hotel, 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, h.search FROM le_resorts r, le_hotels h WHERE h.resortid = r.resortid AND r.resortid = '$resortid' AND h.hotelid = '$hotelid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) echo "

". $row[4] ."

"; if(!empty($row[8])) echo "
". $row[5] . "

"; echo "Hotel Address: " . $row[8] . "

________________________________________

"; $query = "SELECT r.hotelid, r.hotel, h.reviewid, h.hotelid, h.date, h.rating, h.boardbasis, h.bookedthrough, IF(CHAR_LENGTH(h.review)>200,RPAD(LEFT(h.review,200),203,'.'),h.review), h.name, h.email, h.active FROM le_hotels r, le_reviews h WHERE h.hotelid = r.hotelid AND r.hotelid = '$hotelid' ORDER BY h.date DESC LIMIT 0,1"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "

Latest ". $row[1] . " Review

Submitted by: ". $row[9] . "
". $row[8] . " Read More
\"".str_replace("

Check Availability
"; } $query = "SELECT r.resortid, r.resort, r.resortdes, r.resortforumlink, r.sunshine FROM le_resorts r, le_hotels h WHERE h.resortid = r.resortid AND r.resortid = '$resortid' AND h.hotelid = '$hotelid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo " ". $row[4] ."
"; echo "
"; } $query = "SELECT r.resortid, r.resort, h.hotelid, h.resortid, h.hotel, 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, h.hotelreview FROM le_resorts r, le_hotels h WHERE h.resortid = r.resortid AND r.resortid = '$resortid' AND h.hotelid = '$hotelid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo "

". $row[4] ." Reviews

"; echo "
"; } $query = "SELECT r.hotelid, r.hotel, h.reviewid, h.hotelid, h.date, h.rating, h.boardbasis, h.bookedthrough, h.review, h.name, h.email, h.active FROM le_hotels r, le_reviews h WHERE h.hotelid = r.hotelid AND r.hotelid = '$hotelid' ORDER BY h.date ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { if($rowcounter%2==1) $bgcolor="#E5E5E5"; else $bgcolor="#CCCCFF"; echo ""; echo "
Guest Rating: ". $row[5] . "/10
Date of Holiday: ". $row[4] . "
Board Basis: ". $row[6] . "
". $row[8] . "
Submitted by: ". $row[9] . "

Add Your Holiday Review
"; $rowcounter++; } echo "
"; echo ""; $query = "SELECT r.resortid, r.resort, h.hotelid, h.resortid, h.hotel, IF(CHAR_LENGTH(h.hoteldes)>200,RPAD(LEFT(h.hoteldes,200),203,'.'),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 rand()DESC LIMIT 0, 4"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo " "; } echo "
"; $query = "SELECT r.resortid, r.resort, h.hotelid, h.resortid, h.hotel, IF(CHAR_LENGTH(h.hoteldes)>200,RPAD(LEFT(h.hoteldes,200),203,'.'),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 rand()DESC LIMIT 0, 1"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "

Related ". $row[1] . " Hotels

"; } echo "

". $row[4] ."

\"".str_replace("

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