hierarchy system in mysql with php

[eluser]TheFuzzy0ne[/eluser]
Here's a function that doesn't echo anything. It just calls upon itself and builds the string up and passes it back when it's done.

Code:

function doit($tree, $prefix="")
{
    $title = $tree['title'];
    $prefix = ($prefix) ? $prefix.'--'.$title : $title;
    $str = $title."<br />\n";
    if (isset($tree['children']))
    {
        foreach ($tree['children'] as $node)
        {
            $str .= $prefix.'--'.doit($node, $prefix);
            $str .= ( ! isset($node['children'])) ? "<br />\n" : '';
        }
    }
    
    return $str;
}

Hope this helps. You can always add it to your model if you want, but I'd probably keep it as a helper, since it's just formatting data, not actually retrieving any.