Okay, I'm a novice when it comes to programming PHP and MYSQL, but I can usually figure something out when I need to get it done. I'm a bit stumped with this project and need some direction. I need to create a sports scheduler which will automatically generate a season schedule for anywhere between 20-200 teams. Obviously there are rules that need to be followed, which are the following.
non-conference play takes place the first 30-40 days and no conference matchups should take place
conference play would take place around days 35-100 and no non-conference matchups should take place
no more than 50 total games
32 conference games
conference teams should play eachother max 4 times a season
non-conference teams should play eachother max 2 times a season
now, should I start by scheduling day 1 and go forward. Should I start and finish team 1 and then move to team 2 etc. How many database tables should I create (besides the team info table); obviously 1 for actual schedule (gameid, home, away, conference_game, date) but should I also create a reference table to help with the scheduling?
I know this project goes beyond just forum help. I believe I can do the programming and database part I just need some guidance with anyone who has completed a similar project.
Thanks for any help,
Jeff
Sports Scheduler
Moderator: General Moderators