Hi everyone. I am after a chained selects solution for the page: www.ldbsa.co.uk/s_submitscore.php
LEVEL ONE
The first select in the chain I want is the "Division" select box.
LEVEL TWO
If "Premier Division" is selected, the "Home Team" and "Away Team" selects get pre-filled with the records from the following SQL statement.
SELECT Team FROM Premier
Likewise, if "A Division" is selected, the "Home Team" and "Away Team" selects get pre-filled with the records from the following SQL statement.
SELECT Team FROM A
LEVEL THREE
Based on which team is selected from the "Home Team" drop down box, the 7 player name boxes below it will need to be pre-filled with data from the following SQL statement. e.g. if the team name is "Priors_1st"
SELECT Player FROM Priors_1st
Likewise the same for the "Away Team"
Ultimately what I'm trying to do is for this form to be submitted and for the following updates to be carried out:
1. League table to be updated based on the scores entered for each team selected - updating table "Premer" or "A" - (I already have a working script for this)
2. Home team player stats to be updated using the data entered
3. Away team player stats to be updated using the data entered.
Is anybody able to help at all?
LEVEL ONE
The first select in the chain I want is the "Division" select box.
LEVEL TWO
If "Premier Division" is selected, the "Home Team" and "Away Team" selects get pre-filled with the records from the following SQL statement.
SELECT Team FROM Premier
Likewise, if "A Division" is selected, the "Home Team" and "Away Team" selects get pre-filled with the records from the following SQL statement.
SELECT Team FROM A
LEVEL THREE
Based on which team is selected from the "Home Team" drop down box, the 7 player name boxes below it will need to be pre-filled with data from the following SQL statement. e.g. if the team name is "Priors_1st"
SELECT Player FROM Priors_1st
Likewise the same for the "Away Team"
Ultimately what I'm trying to do is for this form to be submitted and for the following updates to be carried out:
1. League table to be updated based on the scores entered for each team selected - updating table "Premer" or "A" - (I already have a working script for this)
2. Home team player stats to be updated using the data entered
3. Away team player stats to be updated using the data entered.
Is anybody able to help at all?
