\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } include'dataedit/sql.php'; if(intval($_GET['county']) > 0 && intval($_GET['county']) < 142){ $county = intval($_GET['county']);} else{ header("HTTP/1.1 404 Not Found"); header("Location: https://information-britain.co.uk/errordoc.php"); exit(); } $sql = "SELECT `desc`, CountyDetails.CountyName, CountyNameCut, CountyDetails.CountryID, bcomregion FROM attraction INNER JOIN CountyDetails ON attraction.county = CountyDetails.RecordID WHERE attraction.county = $county"; $t = mysql_query($sql)or die("$sql\n".mysql_error()); $title = mysql_fetch_object($t); if(mysql_num_rows($t) == 0){ header("HTTP/1.1 404 Not Found"); header("Location: https://information-britain.co.uk/errordoc.php"); exit(); } $q= mysql_query("SELECT EstDetails.Name, EstDetails.RecordID, EstDetails.EstType, EstDetails.Town FROM EstDetails WHERE EstDetails.County = $county AND EstType = 3 OR EstDetails.County2 = $county AND EstType = 3 OR EstDetails.County = $county AND EstType = 10 ORDER BY Town, Name")or die(mysql_error()); mysql_data_seek($q, 0); $number = mysql_num_rows($q); //echo "SELECT * FROM famous WHERE birthcounty = $county OR deathcounty = $county "; $fa = mysql_query("SELECT * FROM famous WHERE birthcounty = $county OR deathcounty = $county ")or mailjim('famous', mysql_error()); //echo'
num rows: '.mysql_num_rows($fa); $events = mysql_query("SELECT eventid, event, events.month AS emonth, location, town, months.month, day, detailcounty FROM events INNER JOIN months ON months.id = events.month WHERE county = $county AND ( exactdate = '0000-00-00' OR exactdate >= NOW() ) ORDER BY emonth, event")or mailjim('events', mysql_error()); $sql="SELECT DISTINCT AttractionType.Name, subset FROM AttractionType INNER JOIN EstDetails ON AttractionType.ID = EstDetails.AttractionType AND EstDetails.County = $county ORDER BY Name"; $typelist = mysql_query($sql)or die(mysql_error()); echo << Wildlife parks, stately homes and family attractions in $title->CountyName, Information Britain Lists these $title->CountyName Attractions and Days out plus many more EOT; ?>
CountyNameCut); include'locallinks.php'; $llins = new locallinks($county,$title->CountryID); echo $llins->output; /*include'featuredhotels.php'; feature($county);*/ include'adviva.txt'; include'burstmedia.txt';; ?>
CountyName''>
"; } */ include'yellowbcombox.php'; yellowbox($title->CountyName,$title->bcomregion); include'connect.php'; connect('', '', "Places to Visit in $title->CountyName"); $picarray = array(); while($picrow = mysql_fetch_object($q)){$picarray[] = array($picrow->RecordID, $picrow->Name);} shuffle($picarray); /*if(!function_exists('file_exists')){ function file_exists($path){ return (@fopen($path,"r")==true); } }*/ foreach($picarray as $item){ if(file_exists("hotelimages/{$item[0]}a.jpg")){ echo""; break; } } mysql_data_seek($q, 0); ?> 0){ echo"

$title->CountyName Events

"; $monthcheck = ''; while($row= mysql_fetch_object($events)){ if($monthcheck != $row->month){ echo"$row->month
\n"; $monthcheck =$row->month; } echo"$row->event
\n"; } echo'

'; } include'travelzoo.txt'; include'yeddabox.txt'; ?>
$number Places to Visit in $title->CountyName | Directory\n"; include'linkunit.txt'; echo"
"; if(!empty($title->desc)){echo"

$title->desc

\n

";} $chk = ''; $count = 1; while($row = mysql_fetch_object($q)){ if($chk != $row->Town){ if($count != 1){echo' | ';} echo"\n$row->Town"; $chk = $row->Town; $count ++; } } if(mysql_num_rows($q) > 0){mysql_data_seek($q, 0);} echo"

Click for comprehensive $title->CountyName information

\n"; if(mysql_num_rows($fa) > 0){ $bpcheck = 0; echo'

'; while($fambrit = mysql_fetch_object($fa)){ if($fambrit->birthcounty == $county && $bpcheck == 0){ echo'Birthplace of: '; $bpcheck = 1; } if($fambrit->birthcounty == $county){echo"$fambrit->name, \n";} } } echo'

'; $chk = ''; $count = 1; while($row = mysql_fetch_object($q)){ if($chk != $row->Town){ if($chk != ''){echo'';} echo"\n

$row->Town

\n
    "; $chk = $row->Town; } echo"
  • $row->Name
  • \n"; if($row->EstType == 10){$feat = 1;} } echo'
'; if(isset($feat)){ echo"

Click here for other attractions in $title->CountyName

\n"; } echo"

For our main $title->CountyName page click here


\n"; include'dailyfeature.php'; ?>