prepare("
SELECT s.*, c.name as course_name
FROM scores s
JOIN courses c ON s.course_id = c.id
WHERE s.player_name = :player_name
ORDER BY s.played_at DESC
");
$stmt->execute([':player_name' => $playerName]);
$rounds = $stmt->fetchAll();
} catch (PDOException $e) {
// Handle DB error
}
?>
Player Stats - <?php echo htmlspecialchars($playerName); ?>