i'm trying to create a recrusive parent child meny on my site. somehow my code doesn't work:
Code: Select all
function LoadMeny($parent_id = 0, $level = 0)
{
global $db;
$query = $db->query("SELECT page_id, parent_id FROM ".DB_PAGES."
WHERE parent_id='$parent_id' ORDER BY order_id"
);
$meny = array();
while($row = $db->fetch_array($query))
{
$meny[] = array(
'page_id' => $row['page_id'],
'level' => $level
);
$meny = array_merge($meny, LoadMeny($row['parent_id'], $level + 1));
}
return $meny;
}