public function retrieveCaptainFromBook($captain_id) { $db = DatabaseBook::getInstance(); $mysqli = $db->getConnection(); $query = "SELECT * FROM ea_users WHERE id = {$captain_id}"; $result = $mysqli->query($query); $counter = 0; $captList = array(); while ($news_row = $result->fetch_array()) { $captain = new Captain(); $captain->setFirstName($news_row['first_name']); $captain->setLastName($news_row['last_name']); $captain->setEmail($news_row['email']); $captain->setStreet($news_row['address']); $captain->setCity($news_row['city']); $captain->setState($news_row['state']); $captain->setZip($news_row['zip_code']); $captain->setCaptainId($news_row['id']); $captList[$counter] = $captain; $counter++; } return $captList; }