get_row("SELECT pages.ID,pages.Name,pages.filename,pages.url,pages.Title,pages.MetaDescription,pages.H1,pages.PagePhoto,pages.Photo1_URL,pages.Photo1_LinkURL,pages.Photo1_Caption,pages.Gallery_Exists,pages.Gallery_ID,pages.Gallery_URL,pages.Country,pages.County,pages.Town,pages.subregion,pages.Cluster,pages.Tags,pages.Parent_ID,pages.Category_ID,pages.RelatedCategories,pages.AttractionID,pages.Summary,pages.Paragraph1,pages.Paragraph2,pages.Paragraph3,pages.Paragraph4,pages.Paragraph5,pages.ParagraphLast,pages.Related_URL1,pages.Related_URL2,pages.Related_URL3,pages.Related_Title1,pages.Related_Title2,pages.Related_Title3,pages.Events,pages.Status,pages.content_body,pages.leftnav,pages.rightnav,pages.GazetteerType,pages.GazetteerWhere,pages.Template,pages.timestamp,pages.Publication_Date,pages.showauthor,pages.License,categories.ID AS CategoryID,categories.Category_Name AS CategoryName,categories.Category_URL AS Category_URL FROM pages INNER JOIN categories ON pages.Parent_ID = categories.ID WHERE pages.ID = '9746' LIMIT 1")) { //make sure the current date is past the Publication_Date $current_date = date("Y-m-d"); $Publication_Date = $content->Publication_Date; if($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; $leftnav = $content->leftnav; $rightnav = $content->rightnav; $Template = $content->Template; $url = $content->url; $filename = $content->filename; $filepath = $url .$filename; $db_showauthor=$content->showauthor; $db_content_body=$content->content_body; // 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; if(!empty($dbtags)) { $tagpieces = explode("||", $dbtags); } include("domain.php"); $canonical = $domain .$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"); } ?>