I have created a form to save new "Players". In the form I have a dropdown  menu where I can select the position of the player in the field. However, when I click save everything gets saved to the database except the info selected from the dropdown. 

The dropdown uses a SQL query to show  the data located in the "Positions" column from the "Positions" table as I am asked from my teacher to do so (green already works, orange doesn't work):

"Player position is selected from drop down menu

• create new data structure and store player positions in the new structure
• use SQL-query to get the list of all possible player positions and display the contents of the list in position drop-down list
• if positions are fetched some other way, full point will not be granted for this assignment
• team name is selected from drop down menu
• save data to data base (Partially works)
• add Back button to navigate back to the start screen."

I can't seem to figure out what is missing. Any help is much appreciated! Below I included a copy of my project.