[solved] Making a parentlist of id

Try making a recursive function.
Maybe this will work:

PHP Code:

private function get_parents($fid, &$parents = array())
{
   $this->db->where('fid', $fid);
   $this->db->where('pid >', 0);
   $query = $this->db->get('forum');
   if ($query->num_rows() > 0) {
      foreach($query->result() as $row) {
         $parents[] = $row->pid;
         $this->get_parents($row->fid,$parents);
      }
   }   
   return $parents; 
}