\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } include'dataedit/sql.php'; $qs = ''; $title = "An A-Z of British Lore and Legend"; $desc = "The Legends of Britain. Regional Stories of British Folklore handed down through the mists of time"; if(isset($_GET['title'])){ $name = mysql_real_escape_string($_GET['title']); $sql = "SELECT id, title FROM Lore WHERE title LIKE '%$name%' ORDER BY title"; $q = mysql_query($sql)or mailjim("q1", "$sql\n".mysql_error()); $text = "

Results for your Lore Britain search on '$name':

\n"; $title = "Search Lore Britain for '$name'"; $desc = "Lore Britain: '$name'"; } elseif(isset($_GET['showall'])){ $sql = "SELECT id, title FROM Lore ORDER BY title"; $q = mysql_query($sql)or mailjim("q3", "$sql\n".mysql_error()); $text = "

Full search of Lore Britain:

\n"; $title = "British Lore and Legend full list"; $desc = "British Lore and Legend: All our entries on one page"; } elseif(isset($_GET['county'])){ $county = intval($_GET['county']); $sql = "SELECT id, title, CountyName, bcomregion FROM Lore LEFT JOIN CountyDetails ON CountyDetails.RecordID = Lore.county WHERE county = '$county' OR county2 = '$county' OR county3 = '$county' ORDER BY title "; $q = mysql_query($sql)or mailjim("q2", "$sql\n".mysql_error()); $cname = mysql_fetch_object($q); mysql_data_seek($q, 0); $text = "

British Lore and Legend, $cname->CountyName:

\n"; $title = "British Lore and Legend, $cname->CountyName"; $desc = "British Lore and Legend in $cname->CountyName, information on British Lore and Legend"; $qs = "?county=$county"; } $co = mysql_query("SELECT DISTINCT RecordID, CountyName, Country.Name AS cname, Country.ID AS cid, COUNT(*) AS num FROM CountyDetails INNER JOIN Lore ON (Lore.county = CountyDetails.RecordID OR Lore.county2 = CountyDetails.RecordID OR Lore.county3 = CountyDetails.RecordID) INNER JOIN Country ON Country.ID = CountyDetails.CountryID GROUP BY CountyName ORDER BY cid, CountyName")or mailjim("co", 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 Lore ORDER BY RAND()"; $pdata = mysql_query($sql);// or die(mysql_error()); $pageurl = $_SERVER['REQUEST_URI']; $cpcount = mysql_query("UPDATE pagecounter SET pagecount=pagecount+1 WHERE pageurl = '$pageurl'"); if(mysql_affected_rows()==0){$cpcount = mysql_query("INSERT INTO pagecounter(pageurl, pagecount, firstday) VALUES ('$pageurl', 1, NOW())");} $cq = mysql_query("SELECT pagecount FROM pagecounter WHERE pageurl = '$pageurl' "); $gcq = mysql_fetch_object($cq); $vcount = $gcq->pagecount; echo <<$title EOT; ?>
CountyName)){ include'yellowbcombox.php'; yellowbox($cname->CountyName,$cname->bcomregion); } include'connect.php'; connect('', '', 'British Lore and Legend', $vcount, '28th February 2011'); ?>
British Lore and Legend
\n"; include'linkunit.txt'; ?>

Enter all or part of a name: 

'; if(isset($q)){ $count = 1; while($row = mysql_fetch_object($q)){ echo"$row->title"; if($count < mysql_num_rows($q)){echo"
\n";} $count ++; } } if(empty($_GET)){ if(!function_exists('file_exists')){ function file_exists($path){ return (@fopen($path,"r")==true); } } while($picrow = mysql_fetch_object($pdata)){ if(file_exists("images/Lore/$picrow->id.jpg")){ echo""; break; } } ?>

Thanks to its rich mix of cultures - Ancient British, Celtic, Anglo-Saxon, Norse and Norman - Britain enjoys an equally varied inheritance of myths and legends. With the arrival of new cultures and peoples over the last century or so it is likely that further additions to this stock are already being made.

As with our folk customs, some of the myths and legends can be traced to a particular source, and some remain delightfully mysterious. In the mysterious category are those known to all, like Robin Hood, and King Arthur, a boon to film and television producers now as they were to poets and minstrels centuries ago.

Arthur is at the grander end of the scale, his story symbolising the coming together of the kingdom, and bound up with what some are wont to call 'British values', of courtesy and honour and fairness. Equally interesting, however, are those local legends, like The Dancers of Stanton Drew, or the myth of how The Wrekin was formed: these are stories perhaps first told by some mother or father to wide-eyed children a thousand and more years ago, where an explanation of some feature of the area gave scope for imagination and entertainment then as it still does now.

Enjoyably - for some at least - our myths and legends include some pleasingly gruesome tales: Black Shuck the ghost dog of East Anglia whose tale has kept children awake for longer than is good for them for a millennium and more; down to far more recent times, and the tragic but attractively melodramatic true story of The Murder in the Red Barn. Knowing the major myths is part of our cultural heritage, part of our particular language. Knowing the local ones adds to the richness of a visit to an area, or the feeling of belonging to that area for its residents. That feeling of belonging, however, goes beyond mere geography, and into the historical, linking us with our ancestors who have shivered as children on hearing about the ghost of Colonel Sydney in Ranworth in Norfolk, or Dando's ghoulish dogs in Cornwall, and as adults have related the same unsettling narratives to their own offspring. Long may it continue.

British Lore and Legend by county: Show All

'; while($cou = mysql_fetch_object($co)){ if($check != $cou->cname){ echo"$cou->cname: "; $check = $cou->cname; } echo"$cou->CountyName($cou->num) | \n"; } ?>