How to build menu with single query?

[eluser]Zorancho[/eluser]
Yes it's a good practice to use recursive function and build an array with all the relationships.
Check out the CI code is using lots of recursive functions such as:

Code:

function escape_str($str)
{
   if(is_array($str))
   {
      foreach($str as $key => $val)
      {
         $str[$key] = escape_str($val);
      }
      return $str;
   }
   else
   {
      return mysql_real_escape_string($str);
   }
}