创建一个PHP脚本，根据从下拉列表中选择的参与方列表加载可用职位。
对于每个可用职位，从数据库中检索已为该职位添加的候选人计数。
将候选者的计数与该位置的max_candidate值进行比较。
如果任何职位的候选人计数超过允许的最大值，请禁用在下拉列表中为该职位添加候选人的选项，或显示消息通知用户没有可用的插槽
示例：

// Assuming you have already retrieved the selected party list ID from the dropdown
$selectedPartyListID = $_POST['partylist_id'];

//Define maximum candidates
$maxCandidate = 2;

// Query to retrieve available positions for the selected party list
$query = "SELECT position_id, posname FROM TbPositions WHERE party_id = $selectedPartyListID";

$result = $dbConnection->query($query);

if ($result) {
    // Loop through available positions
    while ($row = $result->fetch_assoc()) {
        $positionID = $row['position_id'];
        $positionName = $row['posname'];

        // Query to count candidates for this position
        $candidateCountQuery = "SELECT COUNT(*) as candidate_count FROM candidates WHERE position_id = $positionID";

        $candidateCountResult = $dbConnection->query($candidateCountQuery);

        if ($candidateCountResult) {
            $candidateCountRow = $candidateCountResult->fetch_assoc();
            $candidateCount = $candidateCountRow['candidate_count'];

            // Compare with max_candidate
            if ($candidateCount < $maxCandidate) {
                // Add this position as an option in your HTML dropdown
                echo "<option value='$positionID'>$positionName</option>";
            } else {
                // If max candidates are reached for this position, skip adding it to the dropdown or display a message
                echo "<option disabled>$positionName (No Slots Available)</option>";
            }
        } else {
            // Handle database query error
        }
    }
} else {
    // Handle database query error
}