\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } include'dataedit/sql.php'; $title = "An A-Z of Natural Britain"; $desc = "The most naturally beautiful parts of Britain. 300 areas to visit and explore"; if(isset($_GET['title'])){ $name = mysql_real_escape_string($_GET['title']); $sql = "SELECT id, title FROM `Natural` WHERE title LIKE '%$name%' ORDER BY title"; $q = mysql_query($sql)or mailjim("q1", "$sql\n".mysql_error()); $text = "Results for your Natural Britain search on '$name':
\n"; $title = "Search Natural Britain for '$name'"; $desc = "Natural Britain: '$name'"; } elseif(isset($_GET['showall'])){ $sql = "SELECT id, title FROM `Natural` ORDER BY title"; $q = mysql_query($sql)or mailjim("q3", "$sql\n".mysql_error()); $text = "Full search of Natural Britain:
\n"; $title = "Natural Britain full list"; $desc = "Natural Britain: All our entries on one page"; } elseif(isset($_GET['county'])){ $county = intval($_GET['county']); $sql = "SELECT id, title, CountyName FROM `Natural` LEFT JOIN CountyDetails ON CountyDetails.RecordID = `Natural`.county WHERE `Natural`.county = $county OR `Natural`.county2 = $county OR `Natural`.county3 = $county OR `Natural`.county3 = $county OR `Natural`.county4 = $county OR `Natural`.county5 = $county OR `Natural`.county6 = $county OR `Natural`.county7 = $county OR `Natural`.county8 = $county OR `Natural`.county9 = $county OR `Natural`.county10 = $county ORDER BY title "; $q = mysql_query($sql)or mailjim("q2", "$sql\n".mysql_error()); $coun = mysql_query("SELECT CountyName, bcomregion FROM CountyDetails WHERE RecordID = $county")or mailjim("q2", "$sql\n".mysql_error()); $cname = mysql_fetch_object($coun); $text = "

The $cname->CountyName Landscape:
\n"; $title = "Natural Britain, $cname->CountyName"; $desc = "Natural Britain in $cname->CountyName, information on Natural Britain"; } $co = mysql_query("SELECT DISTINCT RecordID, CountyName, Country.Name AS cname, Country.ID AS cid, COUNT(*) AS num FROM CountyDetails INNER JOIN `Natural` ON (`Natural`.county = CountyDetails.RecordID OR `Natural`.county2 = CountyDetails.RecordID OR `Natural`.county3 = CountyDetails.RecordID OR `Natural`.county4 = CountyDetails.RecordID OR `Natural`.county5 = CountyDetails.RecordID OR `Natural`.county6 = CountyDetails.RecordID OR `Natural`.county7 = CountyDetails.RecordID OR `Natural`.county8 = CountyDetails.RecordID OR `Natural`.county9 = CountyDetails.RecordID OR `Natural`.county10 = CountyDetails.RecordID) INNER JOIN Country ON Country.ID = CountyDetails.CountryID GROUP BY CountyName ORDER BY cid, CountyName")or mailjim("co", "$sql\n".mysql_error()); if(isset($q) && mysql_num_rows($q) == 0){ $text = 'Sorry, we dont have any results for your search. Please try again'; } $sql = "SELECT id, title FROM `Natural` ORDER BY RAND()"; $pdata = mysql_query($sql);// or die(mysql_error()); echo << $title EOT; ?>

Related links:

Wildlife | Attractions | Geography

id, $picrow->title);} shuffle($picarray); /*if(!function_exists('file_exists')){ function file_exists($path){ return (@fopen($path,"r")==true); } }*/ foreach($picarray as $item){ if(file_exists("images/natural/{$item[0]}.jpg")){ echo"{$item[1]}{$item[1]}"; break; } } mysql_data_seek($q, 0); if(isset($county)){ include'yellowbcombox.php'; yellowbox($cname->CountyName,$cname->bcomregion); } include'connect.php'; connect('', '', 'Natural Britain'); ?>

Natural Britain | Show All

$text

";} else{ if(!function_exists('file_exists')){ function file_exists($path){ return (@fopen($path,"r")==true); } } while($picrow = mysql_fetch_object($pdata)){ if(file_exists("images/natural/$picrow->id.jpg")){ echo""; break; } } ?>

Stretching more than 750 miles from subarctic Shetland to the very temperate Channel Islands, Britain offers a fantastic diversity of habitats and wildlife. On paper ours can seem like crowded isles, holding more than 60 million people, but our propensity for gathering in towns and cities leaves some vast spaces with little or no population to disturb the flora and fauna.

Just a run through of some of the habitats within relatively easy reach of most in Britain starts to build a picture of what is on offer: the Norfolk Broads; Lincolnshire Fens; the moors in Yorkshire and Lancashire in the North and Devon and Cornwall in the South; the rolling downland of Sussex and Hampshire; the Scottish Highlands, where in the space of a few miles there can be loch, mountain and seashore; Cumbria's Lakeland; the Welsh mountains. Add to those the Somerset Levels; the remaining heathland of Dorset; the sandstone Weald of Kent and Sussex and the list is still far from exhaustive.

Each habitat has its wildflowers and its creatures. We are famous for our birding, but equally fascinating are the lizards, the small mammals and the insects. Happily we now seem to have stepped back from many of the farming practises that devastated wildlife last century; and we are even actively reintroducing species like the sand lizard in mid-Wales, the Red Kite in Tyneside; and the beaver in Scotland.

And we cannot forget the seas that surround us. Watching killer whales off Scotland's northerly outposts is an awe-inspiring experience; as is catching a barracuda or spotting a sunfish off the shores of Southern England - very rare events still but as the world warms... Wildernesses like St Kilda offer the chance to see seabird colonies and seals in the raw; but closer to home reserves like Blakeney, St Abbs and Spurn Head are equally fascinating. And just strolling along almost any beach you may spot dramas like mackerel driving sprats ashore.

Our love for the countryside sees more than a million of us in the RSPB, and four times that number in Britain's National Trusts. But you don't need to belong to any organisation or pay any fees to enjoy Natural Britain. You just need to get out there and use your senses.

'; while($row = mysql_fetch_object($q)){ echo"$row->title
\n"; if($count == $di){echo'

';} $count ++; } echo'

'; } else{ echo'

'; while($row = mysql_fetch_object($q)){ echo"$row->title\n"; if($count < mysql_num_rows($q)){echo"
\n";} $count ++; } echo'

'; } } ?>

Click below to list Natural Britain by county:

Show All cname){ echo"
$cou->cname:"; $check = $cou->cname; } echo"
$cou->CountyName($cou->num)\n"; if($count == $num)echo'

'; $count ++; } ?>

click for strange British folk customs