getConnection(); $query = "SELECT id, name FROM tier_lists ORDER BY created_at DESC"; $stmt = $db->prepare($query); $stmt->execute(); $tierlists = $stmt->fetchAll(PDO::FETCH_ASSOC); echo json_encode($tierlists); ?>