MPTtree, Hieararchical trees in a database table

[eluser]omerorhan[/eluser]
Ok i've done it with sql.

Code:

function index()
{
        $data['tree'] = $this->cat_select();
        
        $this->load->view('deneme_form', $data);
}



function cat_select()
    {

        $str = "<select name=\"page_id\" size='15' style='width:300px'>";
                foreach($this->options() as $data)
                {                    
                    $str .= '<option value="'.$data['lft'].'">'.$data['name'].'</option>';    
                }
        
        $str .= "</select>";
        return $str;
        
    }

    function options()
    {
        $sql = "SELECT CONCAT( REPEAT('&nbsp;&nbsp;&nbsp;', COUNT(detail.id) - 1), detay.title) AS name, node.id, node.lft
        FROM table AS node,
        table AS parent,
        table_detail AS detail
        WHERE node.lft BETWEEN parent.lft AND parent.rgt
        AND node.id = detail.page_id
        GROUP BY node.id
        ORDER BY node.lft";
        
        $query = $this->db->query($sql);
        $row = $query->result_array();
        return $row;
    }