[Which variables goes together?]

No need.. found a way..

 

--------------------------

 

$k = 1;

        if ($group[$home] == "" && $group[$away] == "")
        {
            $group[$home] = $k;
            $group[$away] = $k;
            $k = $k + 1;
        }

        if ($group[$home] != "" && $group[$away] != "")
        {
            if ($group[$home] > $group[$away]) $group[$home] = $group[$away];
            if ($group[$home] < $group[$away]) $group[$away] = $group[$home];
        }

        if ($group[$home] != "" && $group[$away] == "")
        {
            $group[$away] = $group[$home];
        }

        if ($group[$home] == "" && $group[$away] != "")
        {
            $group[$home] = $group[$away];
        }

[Which variables goes together?]

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?