Model problem

[eluser]shinokada[/eluser]
Thanks for your help.

I followed your instruction and I have the following model.

Code:

<?php
class MMenu2 extends Model{

    function MMenu(){
    parent::Model();
    }

    function generateTree(&$tree, $parentid = 0) {
        
        $this->db->where ('parentid',$parentid);
        
        // $sql = 'SELECT * FROM menus WHERE parentid = $parentid';
        $res = $this->db->get('menus');
        if ($res->num_rows() > 0) {
            foreach ($res->result_array() as $r) {
                // push found result onto existing tree
                $tree[$r->id] = $r;
                // create placeholder for children
                $tree[$r->id]['children'] = array();
                // find any children of currently found child
                $this->generateTree($r->id, $tree[$r->id]['children']);
            }
        }
    }

}
?>

However this give an error of this.

Code:

A Database Error Occurred

Error Number: 1054

Unknown column 'Array' in 'where clause'

SELECT * FROM (`menus`) WHERE `parentid` = Array