I have a mySQL database of sports statistics which I wish to publish on to a website. I want to have multiple views of the data so I can view a team squad by clicking team name, and also view each game the team has played and stats on each player performance.
Crucially I want an admin section of the site where I can add new match details as they take place each week. I want to add these details using drop down menus which will filter the data - eg. I enter match between Team A and Team B....when I enter the team listings for Team A I want to see each player associated with Team A in the drop down and I can select them for each position on the team. I also need to be able to edit details of players through the website. This section will need to be password protected.