Hi!
In an onlinegame there are teams that has played matches against each other, plenty of teams and they are divided in 16 groups, and i want to know what team's are in the same groups..
All the data is stored in mysql and it looks something like this :
Games played :
Round 1, Team A vs Team B
Round 1, Team C vs Team D
Round 1, Team E vs Team F
Round 1, Team G vs Team H
... and so on
.
Round 2, Team A vs Team E
Round 2, Team C vs Team G
Round 2, Team F vs Team B
Round 2, Team D vs Team H
... and so on
..
Round 3, ..... cont...
..
Now i see that team A,B,E, and F plays in the same group, and i want some way to make the script find these combinations for me..
Whats the best way to find out these groupings?