Creating a menu from a categories table

[eluser]überfuzz[/eluser]
Slightly off topic, maybe.

A day ago, or something, I wrote that I don't like to do spit out sql querys. But when I read this thread I thought, but what if I cache the result in a file. Then I'd be able to rewrite the file only when there's no db hazard.

You need to set up proper html-tags if you try this approach/code. I'm not familiar enough with CI to scrabble it down in CI style. :red:

Code:

function makeMenu($parent = 0)
{
   $getLinks = mysql_query("/* query the menu stuff you need WHERE parent = $parent */");
   if (mysql_num_rows($getLinks) > 0)
   {
      $list = '';
      while ($row = mysql_fetch_assoc($getLinks))
      {
           $list .= makeMenu($row['id']);
           $list .= "<br />"; //Just to see if it works.
      }

   }
   return $list; // Cache this in a file!
}

Please tell me how it works... if it does. 8-/