get_row("SELECT pages.*,categories.ID AS CategoryID,categories.Category_Name AS CategoryName,categories.Category_URL AS Category_URL, counties2.content_dir AS content_dir FROM pages INNER JOIN categories ON pages.Parent_ID = categories.ID INNER JOIN counties2 ON pages.County = counties2.name WHERE pages.ID = '8137' LIMIT 1")) { //make sure the current date is past the Publication_Date $current_date = date("Y-m-d"); $Publication_Date = $content->Publication_Date; $GazetteerType = $content->GazetteerType; if ($GazetteerType == 'Town') { $GazetteerTypeDisplay = 'Towns and Villages'; } elseif ($GazetteerType == 'Abbey') { $GazetteerTypeDisplay = 'Abbeys and Monasteries'; } elseif ($GazetteerType == 'Prehistoric') { $GazetteerTypeDisplay = 'Prehistoric Sites'; } elseif ($GazetteerType == 'Castle') { $GazetteerTypeDisplay = 'Castles'; } elseif ($GazetteerType == 'Church') { $GazetteerTypeDisplay = 'Historic Churches'; } elseif ($GazetteerType == 'Historic House') { $GazetteerTypeDisplay = 'Historic Houses'; } elseif ($GazetteerType == 'Historic Property') { $GazetteerTypeDisplay = 'Historic Buildings'; } elseif ($GazetteerType == 'Countryside') { $GazetteerTypeDisplay = 'Countryside'; } elseif ($GazetteerType == 'Roman') { $GazetteerTypeDisplay = 'Roman Sites'; } elseif ($GazetteerType == 'Museum') { $GazetteerTypeDisplay = 'Museums'; } elseif ($GazetteerType == 'Gallery') { $GazetteerTypeDisplay = 'Art Galleries'; } elseif ($GazetteerType == 'Cathedral') { $GazetteerTypeDisplay = 'Cathedrals'; } elseif ($GazetteerType == 'Garden') { $GazetteerTypeDisplay = 'Gardens'; } elseif ($GazetteerType == 'Family') { $GazetteerTypeDisplay = 'Family Attractions'; } if(!empty($content) AND $Publication_Date <= $current_date) { $County = $content->County; $Country = $content->Country; $Town = $content->Town; $Title = $content->Title; $Name = $content->Name; $Gallery_Exists = $content->Gallery_Exists; $AttractionID = $content->AttractionID; $H1 = $content->H1; $topblurb1 = $content->TopBlurb1; $topblurb2 = $content->TopBlurb2; $leftnav = $content->leftnav; $rightnav = $content->rightnav; $Template = $content->Template; $where = $content->GazetteerWhere; $url = $content->url; $filename = $content->filename; $filepath = $url .$filename; $db_showauthor=$content->showauthor; $db_content_body=$content->content_body; //$lat = ''; //$lng = ''; // Here we need to set some values for the breadcrumb nav $townnav =preg_replace('/[^a-zA-Z0-9\-]+/', '_', $Town); //and here we get the related content terms $dbtags = $content->Tags; $tagpieces = explode("||", $dbtags); $canonical = "http://www.britainexpress.com" .$filepath; //$gallery_id = ''; if($db_showauthor == 'N') { $showauthor = 'N'; } if($db_content_body == 'Y') { $content_body="content/$filename"; } //$era = ''; options are: Georgian, Victorian, Medieval, Saxon,Stuart,Modern,Tudor //$type = ''; options are: Person, Event, Heritage include("$Template"); }} else { include ("Article-Missing-Template.htm"); } ?>