Creating dynamic dropdown menu system

[eluser]Pegasus275[/eluser]
let's assume that you have

id int
mnu_id id of parent menu
menu_name
url menu_url
etc...

you need to create function. the recursive function

for example

function my_menu($root_id)//0 for root
{
$menus = $this->db->query("select * from my_menu where mnu_id=$root_id");
if($menus->num_rows() > 0){
foreach($menus->result() as $menu){
$data['menu_id_'.$root_id] = array($menu->id,$menu->name,$menu->url,$menu->etc);
$data['menu_id_'.$root_id.'_child'] = my_menu($menu->id);
}
}
return $data;
}

You will get array of menu items you defined, note: this is just example