query($sql); $navSections = array(); while ($row = mysql_fetch_array($result)) { $navSections[$row['id']]['id'] = $row['id']; $navSections[$row['id']]['name'] = $row['name']; } //////////////////////////////////////////////////////////////////////////////// // this is the homepage, statically assign some variables $pageTitle = "Edinburgh University Christian Union"; //////////////////////////////////////////////////////////////////////////////// // get the content for the three columns $sql = 'SELECT * FROM specialpages WHERE page="home" ORDER BY `order` ASC'; $result = $mysql->query($sql); $pageContent = array(); while ($row = mysql_fetch_array($result)) { $pageContent[$row['option']][$row['id']]['title'] = $row['title']; $pageContent[$row['option']][$row['id']]['value'] = $row['value']; } //////////////////////////////////////////////////////////////////////////////// // get the content for the upcoming events $sql = 'SELECT * FROM calendar WHERE date >= NOW() ORDER BY `date` ASC LIMIT 0, 5'; $result = $mysql->query($sql); $calendar = array(); while ($row = mysql_fetch_assoc($result)) { /*echo "
";
					print_r($row);
			echo "
";*/ $calendar[$row['id']]['title'] = $row['title']; $calendar[$row['id']]['desc'] = $row['desc']; $calendar[$row['id']]['date'] = $row['date']; $calendar[$row['id']]['location'] = $row['location']; } //////////////////////////////////////////////////////////////////////////////// // Assign contents to variables for the template $smarty->assign('title', $pageTitle); // This is the page title, as displayed in the title bar $smarty->assign('content', $pageContent); // This is the page content! $smarty->assign('navSections', $navSections); // This is the links for the navigation bar $smarty->assign('calendar', $calendar); //$smarty->assign('insideSections', $insideSections); // This is for the sub-sections of this section //$smarty->assign('sectionPages', $sectionPages); // This is for all the pages which belong to this category $smarty->assign('SITE_URL', SITE_URL); //////////////////////////////////////////////////////////////////////////////// $smarty->display('index.tpl'); ?>