"; echo "
"; $query = "SELECT * FROM le_newhome"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "". $row[1] . ""; } echo " "; echo "
"; echo "

Cheap Egypt Hotels

"; $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 ORDER BY rand()DESC LIMIT 0, 2"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "
". $row[4] ."
\"".str_replace("

"; } echo "

Egypt Holiday Reviews

There are many hotels to stay in, each with their own special character and individuality. We have travelled extensively to Egypt and researched many of them, so you can relax in the knowledge that you are getting accurate hotel descriptions and unbiased information when planning your next holiday to Egypt.

Below is a selection of our users holiday reviews for you to read. If you've recently been to Egypt, then why not leave us a review of your hotel.


"; $query = "SELECT c.hotelid, c.hotel, r.reviewid, r.hotelid, IF(CHAR_LENGTH(r.review)>250,RPAD(LEFT(r.review,250),253,'.'),r.review), r.name, r.email, r.active, c.resortid, t.resortid, t.resort FROM le_hotels c, le_reviews r, le_resorts t WHERE c.resortid = t.resortid AND c.hotelid = r.hotelid ORDER BY rand()DESC LIMIT 0, 3"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo " ".$row[1]."
".$row[4]." [Read More]

"; } echo "
"; echo ""; echo ""; echo ""; echo ""; include ("footer2.php"); ?>