[Phpgroupware-developers] Is there some problem using adodb?

[sigurdne]

it seems like the db-objekt of funcion1 is affekted by function2. Is there a 
way to get around this?

example:

$this->db = $GLOBALS['phpgw']->db;

function function1 ()
{
  $sql = "SELECT * FROM phpgw_accounts";
  $this->db->query($sql,__LINE__,__FILE__);
  while ($this->db->next_record())
  {
    $this->function2($this->db->f('account_id'));
  }
}

function function2 ($account_id)
{
  $sql = "SELECT * FROM phpgw_accounts WHERE account_id = $account_id";
  $this->db->query($sql,__LINE__,__FILE__);
  $this->db->next_record();
  _debug_array($this->db->f('account_lastname'));
}


Regards

Sigurd