created match schedule

[craygo]

I am running a golf league. I am trying to write a web based app to run my league. There is one thing I am having a problem with. The schedule. I need some help with a script which will schedule matches for the season. Some variables will be the number of teams and the weeks played.  MySql will hold player information. The player table will hold name, flight(which is like A, B, C ect...), handicap, and team number. I will have a seperate table which will hold the match information.

Example

we have 8 teams with 4 players on each team
We will be playing 21 weeks.
Need a script that will make a schedule like so

week 1
1 vs 8
2 vs 7
3 vs 6
4 vs 5

week 2
1 vs 7
2 vs 6
3 vs 5
4 vs 8

and so on...
Since the amount of weeks will most likely surpass the matches, It will be OK to repeat the matches once everyone has played a team once.

Hope someone can help

Ray

[craygo]

BUMP!!!  ;D