I would like to add a drop down selection on my php form.
Name -= Onetime
(lookup data is in two tables)
table1 = teams
table2 = picksummary
The teams table has a list of teams.
I would like to lookup the teams in the teams table and then reference the picksummary table to check it the team exists in picksummary.onetime column based on the current week and userid
If the team does exist in that column then do not display the team in the dropdown.