my own helper creating menu

[eluser]Krystian[/eluser]
ok, try to not hate me

look I don`t know how to use your tips and try to do this in model just for test with html tags

model

Code:

function getMenu($parent, $level)
    {
        
        $query = $this->db->query("SELECT a.id id, a.label, a.link, Deriv1.Count FROM `menu` a  LEFT OUTER JOIN (SELECT parent, COUNT(*) AS Count FROM `menu` GROUP BY parent) Deriv1 ON a.id = Deriv1.parent WHERE a.parent=" . $parent);

        $menu .= "<ul id='nav'>";

          
        foreach($query->result() as $position)
        {
            if($position->Count > 0) {
                
                $menu .= "<li><a >link . "'>" . $position->label . "</a>";

                    $this->getMenu($position->id, $level + 1);

                $menu .= "</li>";
                
            }elseif($position->Count == 0) {
            
                $menu .= "<li><a >link . "'>" . $position->label . "</a></li>";
                
            }else;

            }

           $menu .= "</ul>";
          
           return $menu;
    }

in controller

Code:

$data['menuHTML'] = $this->menu_model->getMenu(0, 1);
        
$this->load->view('main_view', $data);

in view simple echo $menuHTML

and it seems like recursive function is not working because I get only the first level.
And notice undefined var menu ;/;/
BUT of course I would like to do in helper