[insert_php]
if(!function_exists(“randomCharacters”)) {
function randomCharacters()
{
$alphabet = “abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUWXYZ0123456789”;

$pass = array(); //remember to declare $pass as an array

$alphaLength = strlen($alphabet) – 1; //put the length -1 in cache

for ($i = 0; $i < 8; $i++) { $n = rand(0, $alphaLength); $pass[] = $alphabet[$n]; } return implode($pass); //turn the array into a string } } else { } $iframeid = randomCharacters(); $search = get_query_var('search'); if (preg_match('/[A-Za-z].*[0-9]|[0-9].*[A-Za-z]/', $search)) { $search_title = strtoupper($search); } else { $search_title = ucwords($search); } if(isset($search_title)) { echo "

Locations of Swimming Venues in $search_title

“;
echo ““;
}

global $db2;

$db2 = new wpdb(‘sd17sw1mk1dz_admin’,’VOtwD~}T_QFw@1*H!d’,’sd17sw1mk1dz_franchiseedb_1′,’localhost’);

$result = $db2->get_results(“SELECT DISTINCT(venues.ID), venues.venuename, venues.street, venues.village, venues.town, counties.description, venues.postcode, venues.daytime_tel_no, venues.image, franchisee.mobile_no, venues.select_private, venues.private_address FROM postcode_county_town, zone_territory, venues, counties, franchisee, assigned_franchisee_zones WHERE counties.county_id = venues.county AND venues.deleted = ‘0’ AND venues.zone_id = zone_territory.ID AND zone_territory.ID = postcode_county_town.territory_id AND (postcode_county_town.sector LIKE ‘%$search_title%’ OR venues.town LIKE ‘%$search_title%’)AND venues.zone_id = assigned_franchisee_zones.zone_id AND assigned_franchisee_zones.franchisee_id = franchisee.ID”);

if($result != NULL)
{
echo “

Please click on a ‘Sharky’ pointer within the map above or choose from a selection of the nearest venues below

“;
}
else
{
echo “

Please click on a ‘Sharky’ pointer within the map above

“;
}

foreach($result as $row)
{
if($row->select_private == ‘1’)
{
$address = $row->private_address . “
 
“;
}
else
{
$address = $row->street . “, ” . $row->village . “, ” . $row->town . “
” . $row->description . “, ” . $row->postcode;
}
echo “

“;
echo “

$row->venuename

image\” alt=\”Swimming\” width=\”100%\” height=\”400px\” />

$address

 

 

town/$row->ID\”>VIEW DETAILS

“;
echo “

“;
}
[/insert_php]