public function getDebts() { $debts = array(); $this->dbQuery("SELECT * FROM debt ORDER BY idDebt"); while ($r = $this->getResult()) { $userStore = new UserStore($this->db); $user1 = $userStore->getUserFromID($r['idUser1']); $user2 = $userStore->getUserFromID($r['idUser2']); $debt = new Debt($r['idDebt'], $user1, $user2, $r['amount']); $debt->setDescription($r['description']); $debt->setPayed($r['payed']); array_push($debts, $debt); } return $debts; }