UltimateNova

Thanks for the reply! You have answered part of my problem but not fully. What I want is add player php page, which would have the following: Name, Date of Birth, Height, Weight, etc But then I need to add a career to the player, you say above that a player can only have one club, that is not necessarily true, one player could play for 2/3 clubs in one season, so I would need some solution to the second part of the player php page that adds a season and a club to the player with their appearances and goals as well. Season: [2014/15 Premier League] Drop Down Select from seasons table Club: [Arsenal] Drop Down Select from clubs table Apps: [10] Manual Input Gls: [5] Manual Input Then we submit and it is displayed on the page something like this, lets say other seasons were added. 2014/15 Premier League - Arsenal - 10 - 5 2013/14 Premier League - Arsenal - 37- 3 2012/13 Premier League - Arsenal - 14- 2 2012/13 Premier League - Chelsea - 11- 2 Thanks

Hi, I am a bit of a MYSQL newbie so please bear with me. I have a database created about football/soccer stats. The database at the moment contains the following tables but more maybe added: Players Clubs Seasons Competitions I will create php pages for these tables that add, edit and delete records for each. But the problem I can't get my head around is how to add a record that uses data from other tables, for example we would add a... player -> club-season-competition Lets say we want create a player called 'Joe Bloggs' and want to add his details, we need somehow for the page to display an option for club, season and competition. Maybe they can be drop down boxes but how does one fill those drop down boxes with records that are already added in the database for each table? Thanks