Drink Responsibly

Available Locations

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 15:

mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, region FROM regions )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 15:

mysql_query(): Access denied for user ”@’localhost’ (using password: NO)

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, region FROM regions )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 15:

mysql_query(): A link to the server could not be established

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, region FROM regions )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 16:

mysql_fetch_array() expects parameter 1 to be resource, boolean given

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, region FROM regions [result] => )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 21:

mysql_free_result() expects parameter 1 to be resource, boolean given

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, region FROM regions [result] => [row] => )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 24:

mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, city FROM cities [result] => [row] => [centres] => Array ( ) )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 24:

mysql_query(): Access denied for user ”@’localhost’ (using password: NO)

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, city FROM cities [result] => [row] => [centres] => Array ( ) )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 24:

mysql_query(): A link to the server could not be established

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, city FROM cities [result] => [row] => [centres] => Array ( ) )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 25:

mysql_fetch_array() expects parameter 1 to be resource, boolean given

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, city FROM cities [result] => [row] => [centres] => Array ( ) )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 29:

mysql_free_result() expects parameter 1 to be resource, boolean given

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT id, city FROM cities [result] => [row] => [centres] => Array ( ) )

Please select a region and centre to view details
 

Region Centre
Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT DISTINCT(region) AS reg FROM events ORDER BY region ASC [result] => [row] => [centres] => Array ( ) )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 46:

mysql_query(): Access denied for user ”@’localhost’ (using password: NO)

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT DISTINCT(region) AS reg FROM events ORDER BY region ASC [result] => [row] => [centres] => Array ( ) )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 46:

mysql_query(): A link to the server could not be established

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT DISTINCT(region) AS reg FROM events ORDER BY region ASC [result] => [row] => [centres] => Array ( ) )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 47:

mysql_num_rows() expects parameter 1 to be resource, boolean given

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT DISTINCT(region) AS reg FROM events ORDER BY region ASC [result] => [row] => [centres] => Array ( ) )

rows is

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 48:

mysql_fetch_array() expects parameter 1 to be resource, boolean given

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT DISTINCT(region) AS reg FROM events ORDER BY region ASC [result] => [row] => [centres] => Array ( ) )

An error occured in script ‘/home/thetrain/public_html/wp-content/plugins/insert-php/insert_php.php(48) : eval()’d code’ on line 179:

mysql_close(): no MySQL-Link resource supplied

Date/Time: 7-20-2017 12:28:47

Array
(
    [content] => [insert_php]
// View centres
//load the config file
require_once('/home/thetrain/includes/config.inc.php');


require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database

// get regions
$region = (isset($_GET['region'])? escape_data($_GET['region']) : "All");
$centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All");

$regions = array();
$query = "SELECT id, region FROM regions";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$regions[$row['id']] = $row['region'];	
}

// get centres
mysql_free_result($result);
$centres = array();
$query = "SELECT id, city FROM cities";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	$centres[$row['id']] = $row['city'];	
}

mysql_free_result($result);

// Get centre filter

echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_content] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] [will_bontrager_matches] => Array ( [0] => Array ( [0] => [insert_php] // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); [/insert_php] ) [1] => Array ( [0] => // View centres //load the config file require_once('/home/thetrain/includes/config.inc.php'); require_once('/home/thetrain/includes/mysql_wp_connect.php'); // connect to the database // get regions $region = (isset($_GET['region'])? escape_data($_GET['region']) : "All"); $centre = (isset($_GET['centre'])? escape_data($_GET['centre']) : "All"); $regions = array(); $query = "SELECT id, region FROM regions"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $regions[$row['id']] = $row['region']; } // get centres mysql_free_result($result); $centres = array(); $query = "SELECT id, city FROM cities"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centres[$row['id']] = $row['city']; } mysql_free_result($result); // Get centre filter echo '

Please select a region and centre to view details
 

Region Centre
'; if ($centre !="All"){ $id = $centre; // Get the data $query = "SELECT * FROM centres WHERE city_id=$id"; // echo "Query is ".$query."
"; $result = @mysql_query($query); //get the records while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $centre_name = $row['city']; echo '

The Training Matrix - Location: '.$centre_name.'

'; echo '
Centre Address '; $addr=explode(",",$row['address']); foreach ($addr as $address) { echo $address."
"; } echo $row['postcode'].'
Telephone '.$row['contact_telephone'].'
Fax '.$row['contact_fax'].'
Website '.$row['website'].'
Disabled Access '; if($row['disabled_access']=="") $row['disabled_access'] == "N/A"; echo $row['disabled_access'].'
Additional Information ' .$row['additional_info'].'
Location '; $centreMap = $row['google_map']; $centreMap = str_replace("#0000FF","#FFFFFF",$centreMap); echo $centreMap.'

Centre Opening Hours

Mon: '.$row['monday'].'
Tue: '.$row['tuesday'].'
Wed: '.$row['wednesday'].'
Thurs: '.$row['thursday'].'
Fri: '.$row['friday'].'
Sat: '.$row['saturday'].'
Sun: '.$row['sunday'].'

'; } mysql_free_result($result); } mysql_close(); ) ) [will_bontrager_nummatches] => 1 [will_bontrager_i] => 0 [live] => 1 [errorEmail] => info@catneyweb.co.uk [region] => All [centre] => All [regions] => Array ( ) [query] => SELECT DISTINCT(region) AS reg FROM events ORDER BY region ASC [result] => [row] => [centres] => Array ( ) )


Copyright © 2012. All Rights Reserved.