<form action="/WAPP1-MalloyE/Scripts/Process_Golfers.php" method="post">
<table border="1">
    <tr>
        <td>First Name:</td>
        <td><input type="text" id="txtFirstName" name="txtFirstName"></td>
    </tr>
    <tr>
        <td>Last Name:</td>
        <td><input type="text" id="txtLastName" name="txtLastName"</td>
    </tr>
    <tr>
        <td>Address:</td>
        <td><input type="text" id="txtAddress" name="txtAddress"></td>
    </tr>
    <tr>
        <td>City:</td>
        <td><input type="text" id="txtCity" name="txtCity"></td>
    </tr>
    <tr>
        <td>State:</td>
        <td><select name="txtState" id="txtState">
        <?php
            $resultSet = $conn->query("SELECT intStateID, strState FROM TStates");
            while ($rows = $resultSet->fetch_assoc())
            {
                $intStateID = $rows['intStateID'];
                $strState = $rows['strState'];
                echo "<option value='$intStateID'>$strState</option>";
            }
            ?>
            </select>
        </td>
    </tr>
    <tr>
        <td>Zip:</td>
        <td><input type="text" id="txtZip" name="txtZip"></td>
    </tr>
    <tr>
        <td>Email Address:</td>
        <td><input type="text" id="txtEmailAddress" name="txtEmailAddress"></td>
    </tr>
    <tr>
        <td>Phone Number:</td>
        <td><input type="text" id="txtPhoneNumber" name="txtPhoneNumber"></td>
    </tr>
    <tr>
        <td>Gender: </td>
        <td><select name="txtGender" id="txtGender">
            <?php
            $resultSet = $conn->query("SELECT intGenderID, strGender FROM TGenders");
            while ($rows = $resultSet->fetch_assoc())
            {
                $intGenderID = $rows['intGenderID'];
                $strGender = $rows['strGender'];
                echo "<option value='$intGenderID'>$strGender</option>";
            }
            ?>
            </select>
        </td>
    </tr>
    <tr>
        <td>Shirt Size:</td>
        <td><select name="txtShirtSize" id="txtShirtSize">
        <?php
            $resultSet = $conn->query("SELECT intShirtSizeID, strShirtSize FROM TShirtSizes");
            while ($rows = $resultSet->fetch_assoc())
            {
                $intShirtSizeID = $rows['intShirtSizeID'];
                $strShirtSize = $rows['strShirtSize'];
                echo "<option value='$intShirtSizeID'>$strShirtSize</option>";
            }
            ?>
            </select>
        </td>
    </tr>
    <tr>
        <td>Team to Represent:</td>
        <td><select name="txtTeamType" id="txtTeamType">
        <?php
            $resultSet = $conn->query("SELECT intTypeofTeamID, strTypeofTeam FROM TTypeofTeams");
            while ($rows = $resultSet->fetch_assoc())
            {
                $intTypeofTeamID = $rows['intTypeofTeamID'];
                $strTypeofTeam = $rows['strTypeofTeam'];
                echo "<option value='$intTypeofTeamID'>$strTypeofTeam</option>";
            }
            ?>
        </select>
        </td>
    </tr>
    </tr>
        <td colspan="2"><input type="submit" id="btnSubmit" name="btnSubmit"></td>
    </tr>
</table>
</form>