createQuery("a")->where("a.page_id is null")->andWhere('a.in_menu = 1')->execute(); foreach($pages as $page){ $arg[$x] = array("name" => $page->getName(),"url"=>'@pages_read?page_slug='.$page->getSlug()); if(stristr($this->getRequestParameter('page_slug'),$page->getSlug())) $arg[$x]['sub'] = $this->getSubcategory($page->getId()); $x++; } return $arg; } private function getSubcategory($id){ $arg = array(); $x = 0; $cat = Doctrine::getTable('Page')->createQuery("a")->where("a.page_id = ".$id)->andWhere('a.in_menu = 1')->execute(); if(!empty($cat)){ foreach($cat as $c){ $arg[$x] = array("name" => $c->getName(),"url"=>'@pages_read?page_slug='.$c->getSlug()); $x++; } return $arg; } return ""; } public function executeMenu() { $this->menu = $this->getMenu(); } } ?>