"; include "includes/add.php"; echo "
"; include "includes/menu.php"; echo "
"; include "includes/toprated.php"; echo "
"; echo ""; echo "



"; $query = "SELECT * FROM ms_hometext LIMIT 1"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "".$row[1].""; } $query = "SELECT COUNT(cid) FROM ms_clubs WHERE active = '1'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "We currently have ".$row[0]." Travel Agents listed in our Travel Agent Directory."; } echo "


"; include "includes/newshops.php"; echo "
"; $query = "SELECT c.cid, c.club, r.crid, r.cid, IF(CHAR_LENGTH(r.comments)>180,RPAD(LEFT(r.comments,180),183,'.'),comments), r.approved, r.rating, r.submittedby, c.townid, t.townid, t.town FROM ms_clubs c, ms_shop_rev r, ms_clubs_town t WHERE c.townid = t.townid AND c.cid = r.cid ORDER BY r.crid DESC LIMIT 0,7"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; } echo "

Latest Travel Agent Reviews

".$row[1]."
".$row[4]." [More Details]

"; include "includes/topshops.php"; echo " "; echo"
"; echo ""; include "footer.php"; ?>