Sports Scheduler

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
houchin
Forum Newbie
Posts: 1
Joined: Thu Mar 16, 2006 7:49 pm

Sports Scheduler

Post by houchin »

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
Post Reply