\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } include('dataedit/sql.php'); $title = "An A-Z of Cultural Britain"; $desc = "Places in Britain made famous by our leading Artistic legends. British Towns and Areas that inspired famous writers, artists, musicians"; if(isset($_GET['title'])){ $name = mysql_real_escape_string($_GET['title']); $sql = "SELECT SQL_CACHE id, title FROM Cultural WHERE title LIKE '%$name%' ORDER BY title"; $q = mysql_query($sql)or mailjim("q1", "$sql\n".mysql_error()); $text = "

Results for your Cultural Britain search on '$name':
\n"; $title = "Search Cultural Britain for '$name'"; $desc = "Cultural Britain: '$name'"; } elseif(isset($_GET['county'])){ $county = intval($_GET['county']); $sql = "SELECT SQL_CACHE id, title, CountyName, bcomregion FROM Cultural LEFT JOIN CountyDetails ON CountyDetails.RecordID = Cultural.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 = "

$cname->CountyName:\n"; $title = "Cultural Britain, $cname->CountyName"; $desc = "Cultural Britain in $cname->CountyName, information on Cultural Britain"; $pageurl = $_SERVER['REQUEST_URI']; $cpcount = mysql_query("INSERT INTO pagecounter(pageurl, pagecount, firstday) VALUES ('$pageurl', 1, NOW()) ON DUPLICATE KEY UPDATE pagecount=pagecount+1"); $cq = mysql_query("SELECT pagecount FROM pagecounter WHERE pageurl = '$pageurl' "); $gcq = mysql_fetch_object($cq); $vcount = $gcq->pagecount; } else{ $sql = "SELECT SQL_CACHE id, title FROM Cultural ORDER BY title"; $q = mysql_query($sql)or mailjim("q3", "$sql\n".mysql_error()); $title = "Cultural Britain full list"; $desc = "Places in Britain made famous by our leading Artistic legends. British Towns and Areas that inspired famous writers, artists, musicians"; } $co = mysql_query("SELECT SQL_CACHE DISTINCT RecordID, CountyName, Country.Name AS cname, Country.ID AS cid, COUNT(*) AS num FROM CountyDetails INNER JOIN Cultural ON (Cultural.county = CountyDetails.RecordID OR Cultural.county2 = CountyDetails.RecordID OR Cultural.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'; } echo <<$title EOT; ?>

Related links:

Theatres | Museums | Events | Folk Customs | Attractions | History

CountyName,$cname->bcomregion); } include'connect.php'; connect('', '', 'Cultural Britain', $vcount, '28th February 2011'); ?>

Cultural Britain

'; include'linkunit.txt'; if(!empty($_GET)){ echo'

'; if(isset($text)){echo $text;} $check = 0; while($row = mysql_fetch_object($q)){ if($check == 1){echo' | ';} echo"$row->title"; $check = 1; } echo'

'; mysql_data_seek($q, 0); } echo'
'; $picarray = array(); while($picrow = mysql_fetch_object($q)){$picarray[] = array($picrow->id, $picrow->title);} mysql_data_seek($q, 0); shuffle($picarray); /*if(!function_exists('file_exists')){ function file_exists($path){ return (@fopen($path,"r")==true); } }*/ foreach($picarray as $item){ if(file_exists("images/cultural/{$item[0]}.jpg")){ echo"{$item[1]}{$item[1]}"; break; } } echo"
\n"; ?>

Those who wander the British countryside, or tramp the streets of our towns and cities, will find it hard to avoid the monuments to and of our history: the castles and cathedrals, churches and canals. But another heritage overlays so many of the same places, a heritage of art and literature and music. In terms of scale our great cathedrals certainly dwarf the little blue plaques and even the statues that commemorate the artists who have contributed so much to our national culture and identity. But in terms of their legacy the judgement is far finer. The landscapes and special places that have inspired the music, the books, the paintings that in turn inspire us can by and large still be enjoyed, providing an extra dimension to the understanding of those works. From Shakespeare to Sayers, The Beatles to the Brontes, from Irvine Welsh to Walter Scott and Benjamin Britten, we hope the guides in this section will facilitate that understanding, or just enhance a visit to the area in question.
These guides serve another purpose too, reminding us of the diversity of landscape within the British Isles. The wilderness of Exmoor in Lorna Doone country contrasted with the gentility of Jane Austen's Hampshire; the bleak Suffolk coast that was so dear to Britten seen against the cosiness of Laurie Lee's Cotswolds; and contrasts in time too, for example in the cityscapes of Delius in Bradford and Lowry in Manchester or more contemporarily Irvine Welsh's Edinburgh. So why not read a good book, or listen to some great music, and lose yourself in the treasure house of art and place that is Cultural Britain.

click for strange British folk customs

British Cultural history by county: Show All

'; mysql_data_seek($co, 0); while($cou = mysql_fetch_object($co)){ if($check != $cou->cname){ echo"$cou->cname: "; $check = $cou->cname; } echo" | $cou->CountyName($cou->num)\n"; } include'dailyfeature.php'; ?>