query(" SELECT p.player_id, CONCAT( p.last_name, ', ', p.first_name, IF(p.middle_initial IS NOT NULL AND p.middle_initial != '', CONCAT(' ', p.middle_initial, '.'), '') ) AS full_name, p.rating, c.club_name FROM players p LEFT JOIN clubs c ON p.club_id = c.club_id ORDER BY p.rating DESC LIMIT 10 "); $topPlayers = $stmt->fetchAll(); } catch (PDOException $e) { error_log("index.php error: " . $e->getMessage()); $topPlayers = []; } include __DIR__ . '/includes/header.php'; ?>

Welcome to Chess Giliw

Your trusted online platform for chess ratings, tournaments, and player records.

Join Now

🏆 Top 10 Players

0): ?> $player): ?>

#	Name	Rating	Club

No players found.

👤

Player Ratings

View up-to-date player ratings with detailed information and history.

📅

Tournaments

Follow upcoming events and keep track of match results and standings.

📝

Admin Tools

Superadmins can manage players, record matches, and update ratings.