Creating a menu from a categories table

[eluser]kikz4life[/eluser]
@skunkbad

did that, parent -> child
btw- you can also sort the order of the parent and child by adding another field also a field for adding the link to the child page.
for the parent = #
for child = controller name

category_id category_name parent_id sort link
1 Examples 0 1 #
2 Stuff 0 2 #
3 Widgets 1 1 cont_name
4 Shiny 3 1 cont_name2
5 Nothing 1 2 cont_name3
so on.....

Code:

Code:

if (isset($navs)) {
    foreach ($navs as $parent)
    {
        $parent_id = "nav_" . $parent['row']['category_id'];
                 echo "link" ....
                   ..........
                   foreach ($parent['child'] as $module)
        {
            $module_id = "nav_" . $module['row']['category_id'];
            $module_link = "#";
            if ($module['row']['link']!="#") {
                $module_link = $module['row']['link'];
                ......
            }
                        echo "link"
                           .................
                           ...........

Just pointed of what ive done. Hope this help..
-Dean