GetRow("SELECT * FROM event LEFT JOIN deanery ON event_deanery = dean_id LEFT JOIN benefice ON event_benefice = ben_id LEFT JOIN church ON event_church = church_id LEFT JOIN parish ON event_parish = parish_id LEFT JOIN event_for ON ef_id = event_for LEFT JOIN contacts ON c_id = event_contactname LEFT JOIN `venue` ON `event`.`event_venue_id` = `venue`.`venue_id` WHERE event_id = '$event_id' AND event_active = 1 GROUP BY event_id"); if (!$event['event_id']){ header("Location: http://www.dioceseofnorwich.org/news/calendar/event-ended"); } $pageTitle = $event['event_title'];//." (Diocese of Norwich)"; // construct your pagetitle } $this->set('pageTitle', $pageTitle); //make your variable available to your view $db = Loader::db(null, null, null, null, true); } } Add an event (Diocese of Norwich)