Social Club Network
The following are social clubs in Alvaston. If you know of a local social club in Alvaston, please use the form to let us know about them. Its free to be listed within the Social Club Network. Our aim is to be a complete directory for Social Clubs, Working Mens Clubs and Sports Clubs throughout the UK.
[ <<< back to county results ]
$sql= "SELECT DISTINCT club_name, club_address_1, club_address_2, club_address_3, club_town, club_county, club_postcode, club_postcode_2, club_telephone, club_fax, club_email, club_website, club_advance_id FROM clubs WHERE club_town = '$_REQUEST[club_town]' AND listing_checked = 'Y' ORDER BY club_name ASC"; $sql_result = mysql_query($sql); if (mysql_num_rows($sql_result) ==0) { echo ("\n"); } else { while ($row = mysql_fetch_array($sql_result)){ $club_name = $row['club_name']; $club_address_1 = $row['club_address_1']; $club_address_2 = $row['club_address_2']; $club_address_3 = $row['club_address_3']; $club_town = $row['club_town']; $club_county = $row['club_county']; $club_postcode = $row['club_postcode']; $club_postcode_2 = $row['club_postcode_2']; $club_telephone = $row['club_telephone']; $club_fax = $row['club_fax']; $club_email = $row['club_email']; $club_website = $row['club_website']; $club_advance_id = $row['club_advance_id']; if ($club_advance_id ==null) { echo ("");} else { echo ("
");}
echo ("\n");
echo ("");
if ($club_address_1 ==null) { echo ("");} else { echo ("$club_address_1, ");}
if ($club_address_2 ==null) { echo ("");} else { echo ("$club_address_2, ");}
if ($club_address_3 ==null) { echo ("");} else { echo ("$club_address_3, ");}
echo ("$club_town, $club_county, $club_postcode $club_postcode_2.
");
if ($club_advance_id ==null) { echo ("");} else { echo ("
\n"); if ($club_advance_id ==null) { echo ("");} else { echo ("
");}
}
}
?>
$club_name
\n"); echo ("");
if ($club_address_1 ==null) { echo ("");} else { echo ("$club_address_1, ");}
if ($club_address_2 ==null) { echo ("");} else { echo ("$club_address_2, ");}
if ($club_address_3 ==null) { echo ("");} else { echo ("$club_address_3, ");}
echo ("$club_town, $club_county, $club_postcode $club_postcode_2.
Telephone: $club_telephone
");
if ($club_email ==null) { echo ("");} else { echo ("Email: $club_email
");}
if ($club_website ==null) { echo ("");} else { echo ("Website: $club_website");}
echo ("
");
if ($club_advance_id ==null) { echo ("");} else { echo ("More Information: MORE INFORMATION
");} echo ("\n"); if ($club_advance_id ==null) { echo ("");} else { echo ("