-
RecordID>$row->Name";
if($row->Address1){echo", $row->Address1";}
echo"\n";
}
echo"
"; if($_GET['type'] != "Pub and Bar"){ if($_GET['type'] == 'Market')include'marketbooks2.txt'; }else{ include'pubbooks3.txt'; } include'dailyfeature.php'; ?>
\r\n";
mail('jim.rolt@googlemail.com', $subject, $error, $headers);
}
switch($_GET['type']){
case 'Pub and Bar':
$typer="Places to Drink";
$title = "Pubs & Bars";
break;
case 'Accountants, Loans, Financial Advisor':
$typer="Financial Services";
$title = "Accountants, Loans, and Financial Advisors";
break;
default:
$typer=$_GET['type'].'s';
$title = $_GET['type'].'s in';
}
include'dataedit/sql.php';
if(isset($_GET['county']) && is_numeric($_GET['county'])){$county = $_GET['county'];}else{$county = 1;}
$q = mysql_query("SELECT DISTINCT EstDetails.RecordID, EstDetails.Name, EstDetails.Address1, EstType, CountyDetails.Countyname, CountyDetails.CountryID
FROM EstDetails
INNER JOIN CountyDetails ON EstDetails.county = CountyDetails.RecordID
INNER JOIN EstablishmentType ON
EstablishmentType.Type = '".mysql_real_escape_string($_GET['type'])."'
AND (EstDetails.EstType = EstablishmentType.ID
OR EstDetails.EstType2 = EstablishmentType.ID
OR EstDetails.EstTypeAlt = EstablishmentType.ID
OR EstDetails.EstType3 = EstablishmentType.ID)
WHERE EstDetails.town = '".mysql_real_escape_string($_GET['town'])."'
AND EstDetails.county = $county
ORDER BY Name ")or mailjim('q',mysql_error());
$row = mysql_fetch_object($q);
if(mysql_num_rows($q) == 1){
header("location:showPlace.cfm?Place_ID=$row->RecordID");
exit();
}
else{mysql_data_seek($q, 0);}
$sql = "SELECT SQL_CACHE RecordID, header, content, link FROM newbanner WHERE EstType = '$row->EstType' AND county = $county";
$nb = mysql_query($sql)or mailjim('nb', mysql_error());
echo <<
Tickets |
Theatre Breaks |
Cinemas |
Hotels |
Performing Arts |
Restaurants
Camping |
Caravan Parks |
Self Catering |
Attractions |
Pubs |
Shops |
Events
Theatres |
Events |
Attractions |
Performing Arts
Film & TV Sets
Clubs |
GastroPubs |
Hotels |
Inns |
Restaurants
Theatres |
Clubs |
Pubs/Bars |
Cinemas |
Racecourses |
Restaurants
Markets |
Shops |
Food shops |
Food legends |
Cultural britain
Healthcare Shops |
Hospitals |
Dentists |
Opticians
Estate Agents |
Accountants |
Office/Stationery shops |
Surveyors
Doctors |
Taxis |
Healthcare Shops |
Hospitals
Historic Houses |
Stately Homes |
Museums |
Clubs |
Pubs/Bars |
Restaurants
Theatres |
Clubs |
Schools |
Cinemas |
Venues |
Cultural Britain
Activities |
Performing Arts |
Fitness Clubs |
Theatres |
Cultural Britain |
Sport
Wildlife |
Attractions |
Doctors |
Natural Britain
RecordID>$row->Name";
if($row->Address1){echo", $row->Address1";}
echo"\n";
}
echo"
";
if($_GET['type'] != "Pub and Bar"){
if($_GET['type'] == 'Market')include'marketbooks2.txt';
}else{
include'pubbooks3.txt';
}
include'dailyfeature.php';
?>