\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } include('dataedit/sql.php'); if(isset($_GET['county']) && is_numeric($_GET['county'])){$county = intval($_GET['county']);}else{$county = 1;} if(isset($_GET['type']) && is_numeric($_GET['type'])){$type = intval($_GET['type']);}else{$type = 1;} $sql = "SELECT CountyDetails.CountyName, CountyNameCut, CountyDetails.CountryID, bcomregion, Country.Name AS Country, Country.Namish AS Countrish, MinorEntries.entryid, MinorEntries.Name, Address, Town, Postcode, Tel, email, `Link`, MinorType.TYPE FROM MinorType INNER JOIN CountyDetails ON CountyDetails.RecordID = $county LEFT JOIN MinorEntries ON MinorType.id = MinorEntries.type AND MinorEntries.County = CountyDetails.RecordID INNER JOIN Country ON CountyDetails.CountryID = Country.ID WHERE MinorType.id = $type ORDER BY Name"; $q = mysql_query($sql)or die(mysql_error());//mailjim('q', "$sql\n".mysql_error()); $byname = mysql_fetch_object($q); if(mysql_num_rows($q) > 0){mysql_data_seek($q, 0);} echo <<$byname->Countrish {$byname->TYPE}s in $byname->CountyName. Find $byname->CountyName {$byname->TYPE}s EOT; ?>
CountyNameCut); include'locallinks.php'; $llins = new locallinks($county,$byname->CountryID); echo $llins->output; /*include'featuredhotels.php'; feature($county);*/ include'adviva.txt'; include'burstmedia.txt';; ?>

Related links:

Doctors | Dentists | Health shops"; break; case 2: // architects echo"Estate Agents | Solicitors | Councils"; break; case 3: // boarding kennels echo"Pet Shops | Wildlife | Open Spaces"; break; case 4: // catteries echo"Kennels | Vets"; break; case 5: // surveyors echo"Estate Agents | Solicitors | Councils"; break; case 6: // leisure centres echo "Sport | Councils | Sports Shops"; break; case 7: // locksmiths echo"Builders | Estate Agents | Plumbers"; break; case 8: // plumbers echo"Builders | Estate Agents | Councils"; break; case 9: // removals echo"Estate Agents | Councils | Road Travel"; break; case 10: // cleaning services break; // blank but here to prevent default below case 12: // mechanics echo"Road Travel | Where to Stay"; break; case 13: // electricians echo"Builders | Electrical Shops"; break; case 14: // driving schools break; // blank but here to prevent default below case 15: // nursery schools echo"Schools | Children's Shops | Days Out"; break; case 16: // gardeners echo"Gardens | DIY Shops | Builders"; break; case 17: // builders echo"Architects | Councils | Plumbers"; break; default: echo"Shops | Attractions | Sport | Hotels"; break; } ?>

CountyName,$byname->bcomregion); include'connect.php'; connect('', '', "{$byname->TYPE}s in $byname->CountyName"); ?>
{$byname->TYPE}s in $byname->CountyName\n"; include'linkunit.txt'; if(mysql_num_rows($q) == 1 && !isset($byname->Name)){ echo"

Sorry, we have no {$byname->TYPE}s in $byname->CountyName, click for nearby counties

"; } else{ echo'

'; while($row = mysql_fetch_object($q)){ $address = nl2br($row->Address); echo <<$row->Name
$address
$row->Town
$row->CountyName
EOT; if(!empty($row->Postcode)){echo"$row->Postcode
\n";} if(!empty($row->Tel)){echo"$row->Tel
\n";} if(!empty($row->email)){echo"email
\n";} if(!empty($row->Link)){echo"Website\n";} echo'

'; } } echo"Click for our main $byname->CountyName pages

"; include'dailyfeature.php'; ?>