March Madness scripting
Posted: Mon Feb 27, 2006 7:57 pm
I know this is a vast app, but does anyone know a way to go about making College Basketball March Madness brackets with php/mysql? Here is an example of how last years played out http://cbs.sportsline.com/collegebasket ... ewable_men
I figured I'd list all the teams that are in it, then have a drop menu for the teams as the brackets get deeper.
Like in the link I posted above (as an example) I would have a drop menu with Illinois and Fair Dickinson as the first round choice. Then the next round would be a drop-menu of Illinois, Fair Dickinson, Texas and Nevada.
So users would pick all the teams they think will make it to the end and submit them. I'll then store the results in a table. Then at the end of the tournament, I would need to run a script basically the same way the users picked their teams with but entering the actual winning teams. Then I would check what the users picked against what the true winners were and I would add a point for each correct pick. Winner would be one with the most points. That make sense to anyone? Is this a good game plan to start with?
And any idea how I should start it??
I figured I'd list all the teams that are in it, then have a drop menu for the teams as the brackets get deeper.
Like in the link I posted above (as an example) I would have a drop menu with Illinois and Fair Dickinson as the first round choice. Then the next round would be a drop-menu of Illinois, Fair Dickinson, Texas and Nevada.
So users would pick all the teams they think will make it to the end and submit them. I'll then store the results in a table. Then at the end of the tournament, I would need to run a script basically the same way the users picked their teams with but entering the actual winning teams. Then I would check what the users picked against what the true winners were and I would add a point for each correct pick. Winner would be one with the most points. That make sense to anyone? Is this a good game plan to start with?
And any idea how I should start it??