hierarchical/adjacency data for nested tree views/menus/ul lists

[eluser]webdude[/eluser]
So far I have ....

Code:

class Blog extends Controller {
    
        function Blog()
        {
            parent::Controller();
        }
    
        function index()
        {

            $this->load->helper('html');
            $query = $this->db->query("select navigation_title as parent_navigation_title from pages where parent_id = 0");
            
            $list = "";
            foreach ($query->result_array() as $row)
            {
                 $list .= $row['parent_navigation_title'].",";
            }            
            
            $alan = split(",", substr_replace($list ,"",-1));
        
            $data['nav_list']= ul($alan);
            $this->load->view('blog_view', $data);

        }
    }

I think I may have a problem with the multi-dimensional arrays as used in the html helper