Else's blog

      $query = $db->query("SELECT * FROM cat where pcatid=0 ORDER BY list");
      $list = array();
          
      while($qs = $db->fetch_array($query))
      {

        $listSub = array();    
        $pid  =$qs['id'];
          $SubQuery = $db->query("SELECT * FROM cat
                     where pcatid=".$qs['id']."
                     ORDER BY list ");
        while($sqs = $db->fetch_array($SubQuery))
        {
          $listSub[]=$sqs;
          $qs['a']=$listSub;
        }
        $list[] = $qs;
      }