function navProjects($status) { if($status == 'current'){ $output = $this->generateList("Project.archived IS NULL", 'created ASC', null, '{n}.Project.id', '{n}.Project.name'); } elseif($status == 'archived'){ $query = "SELECT DISTINCT YEAR(archived) AS year FROM projects,accounts_projects WHERE archived IS NOT NULL "; if ( $_SESSION['Account']['admin'] != 1) { $query .= "AND project_id=id AND account_id = " . $_SESSION['Account']['id']; } $query .= " ORDER BY archived DESC"; $years = $this->query($query); for($i=0;$igenerateList("$condition", 'created ASC', null, '{n}.Project.id', '{n}.Project.name'); } return $output; }