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



"; $query = "SELECT * FROM chi_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 chi_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]." Car Parks listed in our Airport Parking Directory."; } 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 chi_clubs c, chi_shop_rev r, chi_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 ""; } echo "

Latest Airport Parking Reviews

".$row[1]." \"" " .$row[6]. "/10
".$row[4]." [More Details]

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