\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } $type = is_numeric($_GET['type']) ? intval($_GET['type']) : 1; $sql = "SELECT SQL_CACHE STRAIGHT_JOIN DISTINCT CountyName AS name, CountyDetails.RecordID AS id, Country.Name AS Country, Country.ID, MinorType.TYPE FROM MinorType INNER JOIN MinorEntries ON MinorEntries.type = MinorType.ID INNER JOIN CountyDetails ON CountyDetails.RecordID = MinorEntries.County INNER JOIN Country ON Country.ID = CountyDetails.CountryID WHERE MinorType.ID = $type ORDER BY Country.ID, name"; $counties = mysql_query($sql)or mailjim('Counties', "$sql\n".mysql_error()); $coun = mysql_fetch_object($counties); if(mysql_num_rows($counties) > 0){mysql_data_seek($counties, 0);} $title = $type == 4 ? 'Catteries' : $coun->TYPE.'s'; echo <<UK $title. Find $title in every part of England, Scotland, Wales and Offshore EOT; ?>

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 case 12: // mechanics echo"Road Travel | Where to Stay"; break; case 13: // electricians echo"Builders | Electrical Shops"; break; case 14: // driving schools break; // blank 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; } include'connect.php'; connect('', '', "$title in Britain"); ?>

$title in Britain...\n"; include'linkunit.txt'; /* echo <<To search, enter Name or Town, or Both...

  Add Free Entry
EOT; */ include'adtext.php'; if($_GET['type'] == 'Theatre'){ echo'

Book a bargain theatre break here

'; } elseif($_GET['type'] == 'Casino'){echo'

UK Casinos

';} echo'

'; $ccheck = ''; $tcheck = ''; while($row = mysql_fetch_object($counties)){ if($ccheck != $row->Country){echo"$row->Country: \n"; $ccheck = $row->Country; } if($tcheck != $row->id){ echo"id&type={$_GET['type']}\">$row->name | \n"; $tcheck = $row->id; } } echo'

add your business for free

'; include'books.txt'; include'dailyfeature.php'; ?>