\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 << $typer in {$_GET['town']}. the easy way to find a {$_GET['town']} {$_GET['type']} EOT; ?>
EstType){ case 11: ?> 24/7 GP, Click here! CountryID); echo $llins->output; include'adviva.txt'; include'burstmedia.txt';; if($_GET['type'] == 'Market'){include'marketbooks.txt';} include'adviva.txt'; include'burstmedia.txt';; ?>
EstType){ case 14: echo <<Related links:

Tickets | Theatre Breaks | Cinemas | Hotels | Performing Arts | Restaurants

EOT; break; case 15: echo <<Related links:

Camping | Caravan Parks | Self Catering | Attractions | Pubs | Shops | Events

EOT; break; case 24: echo <<Related links:

Theatres | Events | Attractions | Performing Arts Film & TV Sets

EOT; break; case 27://pubs $clink = str_replace(' ', '-', $row->Countyname); echo <<Related links:

Clubs | GastroPubs | Hotels | Inns | Restaurants

EOT; break; case 29: echo <<Related links:

Theatres | Clubs | Pubs/Bars | Cinemas | Racecourses | Restaurants

EOT; break; case 31: echo <<Related links:

Markets | Shops | Food shops | Food legends | Cultural britain

EOT; break; case 34: echo <<Related links:

Healthcare Shops | Hospitals | Dentists | Opticians

EOT; break; case 36://solicitor echo <<Related links:

Estate Agents | Accountants | Office/Stationery shops | Surveyors

EOT; break; case 37: echo <<Related links:

Doctors | Taxis | Healthcare Shops | Hospitals

EOT; break; case 38: echo <<Related links:

Solicitors | Estate Agents

EOT; break; case 42://venue echo <<Related links:

Historic Houses | Stately Homes | Museums | Clubs | Pubs/Bars | Restaurants

EOT; break; case 44: echo <<Related links:

Theatres | Clubs | Schools | Cinemas | Venues | Cultural Britain

EOT; break; case 45: echo <<Related links:

Activities | Performing Arts | Fitness Clubs | Theatres | Cultural Britain | Sport

EOT; break; case 46://vet echo <<Related links:

Wildlife | Attractions | Doctors | Natural Britain

EOT; break; case 47: echo <<Related links:

B & Bs | Inns | Pubs | Budget | Events

EOT; } include'bookingcombox.php'; bookingbox($row->CountyName); ?>
$typer in {$_GET['town']}\n"; include'linkunit.txt'; ?>
 ' name="type" />

"; if($_GET['type'] != "Pub and Bar"){ if($_GET['type'] == 'Market')include'marketbooks2.txt'; }else{ include'pubbooks3.txt'; } include'dailyfeature.php'; ?>