public static function all_game_scores($gameid) { $players = Game::games_players($gameid); $player_scores = array(); foreach ($players as $player) { $sql = "SELECT * FROM score WHERE gameid = :gameid AND playerid = :playerid"; $query = DB::connection()->prepare($sql); $query->execute(array('gameid' => $gameid, 'playerid' => $player->playerid)); $rows = $query->fetchAll(); $scores = array(); foreach ($rows as $row) { $score = new Score(array('scoreid' => $row['scoreid'], 'gameid' => $row['gameid'], 'holeid' => $row['holeid'], 'playerid' => $row['playerid'], 'stroke' => $row['stroke'], 'ob' => $row['ob'])); $score->prepare(); $scores[] = $score; } $player_scores[$player->firstname] = $scores; } return $player_scores; }