"; include "includes/menu.php"; echo "
"; echo "
$town, $county

"; $query = "SELECT * FROM sou_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 sou_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]." listings live on the website."; } echo "


"; $query = "SELECT c.cid, c.club, c.address, c.townid, t.townid, t.town FROM sou_clubs c, sou_clubs_town t WHERE c.townid = t.townid AND c.active = '1' ORDER BY c.cid DESC LIMIT 5"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo ""; echo ""; } echo "
Latest Listings

" .$row[1]. "
" .$row[5]. " in $town
" .$row[2]. "
[More Details]
"; include "includes/topshops.php"; echo "
"; include "footer.php"; ?>