title: Codeigniter error : Fatal error: Cannot use object of type CI_DB_mysql_result as array
body: <p>I'm trying to implement a php codeigniter model for tree and every time I run my controller, I am getting the following error :</p>
  
  <blockquote>
    <p>Fatal error: Cannot use object of type CI_DB_mysql_result as array in
    C:\AppServ\www\tree\application\models\Btree.php on line 50</p>
  </blockquote>
  
  <p>I tried to fix this syntax in line </p>
  
  <pre><code>$currentID = $row['id'];
  </code></pre>
  
  <p>however, still getting the same error message.</p>
  
  <p>My model function is:</p>
  
  <pre><code>public function fetchTree($parentArray, $parentID = null)
  {
      // Create the query
      if ($parentID == null)
          $parentID = -1;
  
      $sql = "SELECT `id` FROM `{$this-&gt;tblName}` WHERE `id`= ". intval($parentID);
  
      // Execute the query and go through the results.
      $result = $this-&gt;db-&gt;query($sql);
      if ($result)
      {
          while ($row = $result)
          {
              // Create a child array for the current ID
              $currentID = $row['id'];
              $parentArray[$currentID] = array();
  
              // Print all children of the current ID
              $this-&gt;fetchTree($parentArray[$currentID], $currentID);
          }
          $result-&gt;close();
      }
  }
  </code></pre>