lastige query

<?php
if(($rResult = mysql_query('SELECT * FROM table')) !== false && mysql_num_rows($rResult) > 0)
{
    function submenu($iCurrent, $aRows, $iLayer = 0)
    {
        foreach ($aRows as $iKey => $aRow)
        {
            if ($aRow['parent_id'] == $iCurrent)
            {
                print str_repeat('- ', $iLayer).$aRow['title'].'<br />';
                
                unset($aRows[$iKey]);
                
                if ($aRow['isagroup'])
                {
                    submenu($aRow['id'], $aRows, $iLayer + 1);
                }
            }
        }
        
        return true;
    }
    
    $aRows = array();
    
    while (($aRow = mysql_fetch_assoc($rResult)) !== false)
    {
        $aRows[] = $aRow;
    }
    
    submenu(0, $aRows);
}
?>

<?php
if(($rResult = mysql_query('SELECT * FROM table')) !== false && mysql_num_rows($rResult) > 0)
{
    function submenu($iCurrent, $aRows, $iLayer = 0)
    {
        foreach ($aRows as $iKey => $aRow)
        {
            if ($aRow['parent_id'] == $iCurrent)
            {
                print str_repeat('- ', $iLayer).$aRow['title'].'<br />';
 
                unset($aRows[$iKey]);
 
                if ($aRow['isagroup'])
                {
                    submenu($aRow['id'], $aRows, $iLayer + 1);
                }
            }
        }
 
        return true;
    }
 
    $aRows = array();
 
    while (($aRow = mysql_fetch_assoc($rResult)) !== false)
    {
        $aRows[] = $aRow;
    }
 
    submenu(0, $aRows);
}
?>

<?PHP
function get_path($id) { 
   // look up the parent of this node 
   echo $sQuery = "SELECT * FROM page WHERE parent_id='".$id."'";
   $rs = $this->conn->Execute($sQuery); 

   // save the path in this array 
   $path = array(); 

   // only continue if this $node isn't the root node 
   // (that's the node with no parent) 
   if ($rs->fields['parent_id']!='0') { 
       // the last part of the path to $node, is the name 
       // of the parent of $node 
       $path[] = $rs->fields['title']; 

       // we should add the path to the parent of this node 
       // to the path 
       $path = array_merge($this->get_path($rs->fields['id']), $path); 
   } 

   // return the path 
   return $path; 
?>

<?PHP
function get_path($id) { 
   // look up the parent of this node 
   echo $sQuery = "SELECT * FROM page WHERE parent_id='".$id."'";
   $rs = $this->conn->Execute($sQuery); 
 
   // save the path in this array 
   $path = array(); 
 
   // only continue if this $node isn't the root node 
   // (that's the node with no parent) 
   if ($rs->fields['parent_id']!='0') { 
       // the last part of the path to $node, is the name 
       // of the parent of $node 
       $path[] = $rs->fields['title']; 
 
       // we should add the path to the parent of this node 
       // to the path 
       $path = array_merge($this->get_path($rs->fields['id']), $path); 
   } 
 
   // return the path 
   return $path; 
?>