public function GetAllProviders() { $table = $this->getDbTable(); $select = $table->select(); $select->from($table, array('id', 'name', 'email', 'phone_1', 'phone_2', 'balance')); $select->where('status = ?', true); $select->order('name ASC'); $resultSet = $table->fetchAll($select); $entries = array(); foreach ($resultSet as $row) { $entry = new Gyuser_Model_Providers(); $entry->setId($row->id); $entry->setName($row->name); $entry->setEmail($row->email); $entry->setPhone_1($row->phone_1); $entry->setPhone_2($row->phone_2); $entry->setBalance($row->balance); $entries[] = $entry; } return $entries; }