Duplicate:
How can I generate a round robin tournament in PHP and MySQL?
I need to generate sequences of games using the round robin algorithm. I have the php page where the user can input the tournament name which will be inserted into the database and it has got a drop down menu up to 32 teams (select number of teams).
So if I select 4 teams in the page, so it will be from team 1 to team 4 which would be 6 matches because every team plays the other team once. I know how the algorithm works but I am not quite sure how to write the query for that. This is what have I done until now:
Array
(
var NoTeams = n;
(i = 1; i < n; i++)
$NewArray[0] = "Team 1";
$NewArray[1] = "Team 2";
$NewArray[2] = "Team 3";
$NewArray[3] = "Team 4";
$NewArray[4] = "Team 5";
$NewArray[5] = "Team 6";
$NewArray[6] = "Team 7";
$NewArray[7] = "Team 8";
$NewArray[8] = "Team 9";
$NewArray[9] = "Team 10";
$NewArray[10] = "Team 11";
$NewArray[11] = "Team 12";
$NewArray[12] = "Team 13";
$NewArray[13] = "Team 14";
$NewArray[14] = "Team 15";
$NewArray[15] = "Team 16";
$NewArray[16] = "Team 17";
$NewArray[17] = "Team 18";
$NewArray[18] = "Team 19";
$NewArray[19] = "Team 20";
$NewArray[20] = "Team 21";
$NewArray[21] = "Team 22";
$NewArray[22] = "Team 23";
$NewArray[23] = "Team 24";
$NewArray[24] = "Team 25";
$NewArray[25] = "Team 26";
$NewArray[26] = "Team 27";
$NewArray[27] = "Team 28";
$NewArray[28] = "Team 29";
$NewArray[29] = "Team 30";
$NewArray[30] = "Team 31";
$NewArray[31] = "Team 32";
)