I am looking to create a database and PHP script that allows me to create a Head to Head Fantasy League Game.
On paper I have this vision where for example (10 members sign up to a league) When the league is full the admin can click (create match-ups) which will then store all the match-ups into the database for each week.
League name: My League
Teams in the league:
Match-ups for (My League)
user1 VS user10 (for example)
user2 VS user9 (for example)
user3 VS user8 (for example)
user4 VS user7 (for example)
user5 VS user6 (for example)
second week everyone plays someone different and so on... over 9 weeks. Everyone plays everyone else once.
So im a bit stuck #1 setting up the database correctly. #2 creating the PHP to work with the database.
If anyone has any ideas or knows a good way to do something like this please help. Thanks.