<p>Welcome to the official results page for the Holland 100, our monthly clay shooting competition at the Holland &amp; Holland Shooting Grounds. Here, you can find the latest scores and rankings, highlighting the top performances from each event. Whether you are competing regularly or joining for the first time, this is the place to follow results and track progress. We look forward to welcoming you to a future fixture.</p>

<p>The Holland 100 Results</p>

<select class="w-full bg-white border-paper border-[1px] rounded-none px-[24px] py-[12px] mb-[24px] text-[14px] focus:outline-none appearance-none" id="competition-select" onchange="getScores()">
<option value="">Select fixture date</option>
</select>
<div id="scores-holder"></div>
<p>
<script>
    var xmlhttp = new XMLHttpRequest();

    xmlhttp.onreadystatechange = function() {
        if (xmlhttp.readyState == XMLHttpRequest.DONE) {
            console.log('Status:', xmlhttp.status);
            console.log('Response:', xmlhttp.responseText);
            
            if (xmlhttp.status == 200) {
                try {
                    var myObj = JSON.parse(xmlhttp.responseText);
                    var sel = document.getElementById('competition-select');
                    
                    // Clear existing options except the first one
                    while (sel.options.length > 1) {
                        sel.remove(1);
                    }
                    
                    // Convert object to array and sort by fixturedate
                    var fixtures = Object.values(myObj).sort((a, b) => {
                        return new Date(b.startTime) - new Date(a.startTime);
                    });
                    
                    for (var i = 0; i < fixtures.length; i++) {
                        // Create targets only option
                        var optTargets = document.createElement('option');
                        optTargets.innerHTML = fixtures[i].startTime + ' (Birds Only)';
                        optTargets.value = fixtures[i].id + '_birds';
                        sel.appendChild(optTargets);

                        // Create competition option
                        var optCompetition = document.createElement('option');
                        optCompetition.innerHTML = fixtures[i].startTime + ' (Competition)';
                        optCompetition.value = fixtures[i].id + '_comp';
                        sel.appendChild(optCompetition);
                    }
                } catch (e) {
                    console.error('JSON parsing error:', e);
                    console.log('Raw response:', xmlhttp.responseText);
                }
            } else {
                console.error('HTTP Status:', xmlhttp.status);
                console.error('Response Text:', xmlhttp.responseText);
            }
        }
    };

    xmlhttp.onerror = function() {
        document.getElementById("scores-holder").innerHTML = 'Unable to load scores, please try again.';
        console.error('Request failed');
    };

    xmlhttp.open("GET", "https://gloriousgame.co.uk/lib/getscores.php?action=get-fixtures", true);
    xmlhttp.send();

    function getScores() {
        var selectedValue = document.getElementById('competition-select').value;
        if (!selectedValue) {
            document.getElementById("scores-holder").innerHTML = ''; // Clear the results
            return;
        }

        var [id, type] = selectedValue.split('_');
        
        var scoresXhr = new XMLHttpRequest();
        scoresXhr.onreadystatechange = function() {
            if (scoresXhr.readyState == XMLHttpRequest.DONE) {
                if (scoresXhr.status == 200) {
                    document.getElementById("scores-holder").innerHTML = scoresXhr.responseText;
                } else {
                    document.getElementById("scores-holder").innerHTML = 'Unable to load scores, please try again.';
                }
            }
        };

        scoresXhr.open("GET", "https://gloriousgame.co.uk/lib/getscores.php?action=get-scores&id=" + id + "&type=" + type, true);
        scoresXhr.send();
    }
</script>
</p>