Tournament Leaderboard

query("SELECT id, name FROM courses ORDER BY name ASC"); $courses = $courses_stmt->fetchAll(); $selected_course_id = isset($_GET['course_id']) ? (int)$_GET['course_id'] : ($courses[0]['id'] ?? 0); ?>

Individual Standings

prepare("SELECT * FROM courses WHERE id = ?"); $course_stmt->execute([$selected_course_id]); $course_details = $course_stmt->fetch(); // Fetch scores for the selected course $stmt = $pdo->prepare(" SELECT s.*, p.name as player_name FROM scores s JOIN players p ON s.player_id = p.id WHERE s.course_id = ? ORDER BY s.total_to_par ASC "); $stmt->execute([$selected_course_id]); $results = $stmt->fetchAll(); } catch (PDOException $e) { $results = []; $course_details = null; echo "

Database error: " . $e->getMessage() . "

"; } } else { $results = []; $course_details = null; } ?>
$row): ?>
Rank Player
() 		Total To Par Actions
No results yet for this course.
$par) $class = 'bg-warning'; // Bogey else $class = 'bg-light'; // Par } echo "{$score}"; ?> 0 ? '+' : '') . $row['total_to_par']; ?> Edit Delete

Team Standings

prepare(" SELECT t.name as team_name, SUM(s.total_score) as total_score FROM scores s JOIN teams t ON s.team_id = t.id WHERE s.course_id = ? GROUP BY s.team_id, t.name ORDER BY total_score ASC "); $stmt->execute([$selected_course_id]); $team_results = $stmt->fetchAll(); } catch (PDOException $e) { $team_results = []; echo "

Database error: " . $e->getMessage() . "

"; } } else { $team_results = []; } ?> $row): ?>
Rank Team Total Score
No team results yet.