Rounds

[Forever_xxl]

I have making league. in mysql a this data:
ID | Team
1 Team A
2 Team B
3 Team C
4 Team D

Using whike funcion I am geting (SELECT a., b. FROM team_data a, team_datai b WHERE a.id != b.id and b.id != a.id )

I am geting
Team A - Team B
Team C - Team D

Team A - Team D
Team B - Team C

and etc.

I want what he show rounds:

Team A - Team B Round 1(1sts round Team A and Team B not yet played)
Team C - Team D Round 1 (1sts round Team C and Team D not yet played)

Team A - Team D Round 2 (round 2 because Team A and Team D played one match)
Team B - Team C Round 2 (round 2 because Team B and Team C played one match)

etc.

How make rounds script. Please help. Need your help 😉

[sidney]

not perfect but may help you work out the problem

  ini_set('max_execution_time','30');//may have to set this high for over 10 teams
require('connect.php');
// number of teams and games/team
$team=mysql_result(mysql_query("SELECT count(team) FROM teamdata WHERE id !=1"),0);//id 1 must be team name BYE
if($team%2==0)
	$bye=" and a.id !=1 and b.id !=1";
else
	{
	$bye='';
	$team++;
	}
$games=$team-1;
$teams=$team/2;

// grab all matches matches[2] contains second round matches
$sql="SELECT a.*, b.* FROM teamdata a, teamdata b WHERE a.id != b.id".$bye; 
$query=mysql_query($sql);
$hold=array();
while($row=mysql_fetch_row($query))
	{
	//place matches in there rounds
	if(!in_array($row[0].$row[2],$hold))
		{
		$hold[]=$row[0].$row[2];
		$hold[]=$row[2].$row[0];
		$matches[1][]= array($row[1],$row[3]);
		}
	else
		$matches[2][]= array($row[1],$row[3]);
	}


// order matches into weeks
$round=rounds($matches[1],$teams,$games);
//$round[2]=rounds($matches[2],$teams,$games);

//display output	
echo'<pre>';
print_r($round);


//function o sort matches into weekly rounds	
function rounds($match,$teams,$games)
	{
	$matches='';
	while(count($matches)>0)
		{
		echo 'itteration <br>';
		$matches=$match;
		for($i=1;$i<=$games;$i++)
			{
			$rounds[$i]=array();
			$hold=array();
			shuffle($matches);
			foreach($matches as $key=>$val)
				{
				if(!in_array($val[0],$hold) && !in_array($val[1],$hold))
					{
					$hold[]=$val[0];
					$hold[]=$val[1];
					$rounds[$i][]=$val[0].' v '.$val[1];
					unset($matches[$key]);
					if(count($rounds[$i])>=$teams)
						break;
					}
				}
			}
		}
	return $rounds;
	}

[Forever_xxl]

everythink be O.K. but I want what teams played with all teams (teams will not be more than 16). Example:
if playing 4 teams. All teams will play 12 matches. Because:
Team A and Team B (first team playing at home).
One team have played 6 match (3 times at home (must be first (Team a - Team B, TEam A - TEam C, TEam a - Team D) and 3 not at home (Team B - Team A, TEam C - TEam A, TEam D - Team A). One team can play only 1 time in rounds. (can't play TEam A in first round 2 times and more.)
Very thanks. That you helping for me 🙂

Your script printing. In mysql a 4 teams. One team playing one match 🙂. Some teams playing with nothings 🙂

itteration
Array
(
    [1] => Array
        (
            [0] => 6 v 3
            [1] => 7 v 
        )

[2] => Array
    (
        [0] => 5 v 
    )

[3] => Array
    (
        [0] => BYE v 
    )
}

[sidney]

id 1 in mysql must be team BYe as it says in comment inscript

// id 1 must be team name BYE 
 

or the sql will need changing to reflect the id of the BYE team

this is here so that if only 3 teams the bye comes into play

to get the second lot of rounds change this bit

  $round=rounds($matches[1],$teams,$games); 
    //$round[2]=rounds($matches[2],$teams,$games);  

to

   $round[1]=rounds($matches[1],$teams,$games); 
    $round[2]=rounds($matches[2],$teams,$games);  

then rounds will have to elements containing the 2 seperate rounds one for home and one for array

note in my limited test of this script i found it did not complete when over 10 teams in db not including BYE

output 3teams and bye

 Array
(
    [1] => Array
        (
            [1] => Array
                (
                    [0] => team C v team A
                    [1] => BYE v team B
                )

        [2] => Array
            (
                [0] => BYE v team A
                [1] => team C v team B
            )

        [3] => Array
            (
                [0] => team B v team A
                [1] => BYE v team C
            )

    )

[2] => Array
    (
        [1] => Array
            (
                [0] => team A v team C
                [1] => team B v BYE
            )

        [2] => Array
            (
                [0] => team A v BYE
                [1] => team B v team C
            )

        [3] => Array
            (
                [0] => team C v BYE
                [1] => team A v team B
            )

    )

)

 

[Forever_xxl]

My data from my sql:
id | Name
BYE | BYE
2 | 5
3 | 6

If more then 3 its only show:
itteration
itteration
itteration
itteration
itteration
itteration
ir etc.

And then 3 show (numbers its teams names. I am not undestand where he get team 3) :
Array
(
[1] => Array
(
[1] => Array
(
[0] => 5 v
)

        [2] => Array
            (
                [0] => 6 v 3
            )

        [3] => Array
            (
                [0] => BYE v 
            )

    )

[2] => Array
    (
        [1] => Array
            (
                [0] => 5 v 
            )

        [2] => Array
            (
                [0] => BYE v 
            )

        [3] => Array
            (
                [0] => 6 v 3
            )

    )

)

[sidney]

Your data from my sql should be:
id | Name
1 | BYE
2 | 5
3 | 6

[Forever_xxl]

nothing:
print:
itteration
itteration
itteration
itteration
itteration
itteration
ir etc.

[sidney]

how many teams in db

[Forever_xxl]

3. And thats all. 🙂
   id | Name
   1 | BYE
   2 | 5
   3 | 6

[sidney]

can you post the code as you have used it
as it works for me up to ten teams

just to note itterration is just a bit of debugging info it shows how may times it failed to find the right configuration of the teams

[Forever_xxl]

<?
ini_set('max_execution_time','30');//may have to set this high for over 10 teams 

mysql_connect("localhost", "forever_xxl", "GoGoGo");
mysql_select_db("Teams");

// number of teams and games/team 
$team=mysql_result(mysql_query("SELECT count(team_name) FROM teams_table WHERE id !=1"),0);//id 1 must be team name BYE 
if($team%2==0) 
    $bye=" and a.id !=1 and b.id !=1"; 
else 
    { 
    $bye=''; 
    $team++; 
    } 
$games=$team-1; 
$teams=$team/2; 

// grab all matches matches[2] contains second round matches 
$sql="SELECT a.*, b.* FROM teams_table a, teams_table b WHERE a.id != b.id".$bye;  

$query=mysql_query($sql); 
$hold=array(); 
while($row=mysql_fetch_row($query)) 
    { 
    //place matches in there rounds 
    if(!in_array($row[0].$row[2],$hold)) 
        { 
        $hold[]=$row[0].$row[2]; 
        $hold[]=$row[2].$row[0]; 
        $matches[1][]= array($row[1],$row[3]); 
        } 
    else 
        $matches[2][]= array($row[1],$row[3]); 
    } 


// order matches into weeks 
$round[1]=rounds($matches[1],$teams,$games);  
$round[2]=rounds($matches[2],$teams,$games);
//$round[2]=rounds($matches[2],$teams,$games); 

//display output     

echo'<pre>'; 
print_r($round); 


//function o sort matches into weekly rounds     

function rounds($match,$teams,$games) 
    { 
    $matches=''; 
    while(count($matches)>0) 
        { 
        echo 'itteration <br>'; 
        $matches=$match; 
        for($i=1;$i<=$games;$i++) 
            { 
            $rounds[$i]=array(); 
            $hold=array(); 
            shuffle($matches); 
            foreach($matches as $key=>$val) 
                { 
                if(!in_array($val[0],$hold) && !in_array($val[1],$hold)) 
                    { 
                    $hold[]=$val[0]; 
                    $hold[]=$val[1]; 
                    $rounds[$i][]=$val[0].' v '.$val[1]; 
                    unset($matches[$key]); 
                    if(count($rounds[$i])>=$teams) 
                        break; 
                    } 
                } 
            } 
        } 
    return $rounds; 
    }
    ?>

It working. I have test it in over hosting. But in hosting which i am using not working.

[sidney]

if thats your reall user and password for mysql i surgest you edit your post and remove the info

[Forever_xxl]

no it's not real. And it possible to make that then run 2 array it's show from firs array last round (+1) and more. then run 2 array. not show rounds from firs: ex.
rray
(
[1] => Array
(
[1] => Array
(
[0] => Team O v Team Z
[1] => Team D v Team B
[2] => Team C v Team A
[3] => Team E v Team F
)

        [2] => Array
            (
                [0] => Team C v Team B
                [1] => Team E v Team A
                [2] => Team O v Team D
                [3] => Team Z v Team F
            )

    )

[2] => Array
    (
        [3] => Array
            (
                [0] => Team D v Team F
                [1] => Team Z v Team O
                [2] => Team B v Team C
                [3] => Team A v Team E
            )

        [4] => Array
            (
                [0] => Team C v Team O
                [1] => Team B v Team F
                [2] => Team D v Team E
                [3] => Team A v Team Z
            )

}

[sidney]

sorry i dont follow your question

[Forever_xxl]

I am getting:
rray
(
[1] => Array
(
[1] => Array
(
[0] => Team O v Team Z
[1] => Team D v Team B
[2] => Team C v Team A
[3] => Team E v Team F
)

[2] => Array
(
[0] => Team C v Team B
[1] => Team E v Team A
[2] => Team O v Team D
[3] => Team Z v Team F
)

)

[2] => Array
(
[1] => Array
(
[0] => Team D v Team F
[1] => Team Z v Team O
[2] => Team B v Team C
[3] => Team A v Team E
)

[2] => Array
(
[0] => Team C v Team O
[1] => Team B v Team F
[2] => Team D v Team E
[3] => Team A v Team Z
)
}

I want what he show:
rray
(
[1] => Array
(
[1] => Array
(
[0] => Team O v Team Z
[1] => Team D v Team B
[2] => Team C v Team A
[3] => Team E v Team F
)

[2] => Array
(
[0] => Team C v Team B
[1] => Team E v Team A
[2] => Team O v Team D
[3] => Team Z v Team F
)

)

[2] => Array
(
[3] => Array //not 1 it's begin from 3 because last round was 2
(
[0] => Team D v Team F
[1] => Team Z v Team O
[2] => Team B v Team C
[3] => Team A v Team E
)

[4] => Array
(
[0] => Team C v Team O
[1] => Team B v Team F
[2] => Team D v Team E
[3] => Team A v Team Z
)
}

And big thanks for help.

[sidney]

somthig like this will out put the round array
making weeks count form 1 to what ever

 foreach($round as $key=>$val)
	{
	$home=($key==1)?'Home':'Away';
	echo '<br />'.$home.'<br />';
	$next=($home=='Away')?count($val):0;//make weeks count from 1 and not restart at 1 for next round
	foreach($val as $wkey=>$wval)
		{
		echo '<br />Week '.($next+$wkey).'<br />'.
		'Home - - - - Away<br />';;
		foreach($wval as $gkey=>$gval)
			{
			if(strpos($gval'BYE')===false)
			echo $gval.'<br />';			}
		}
	} 

[Forever_xxl]

where i have put this code? bettween which code.
And note how make more fields? Script not working if i create more fields.
i want in table create more fields. 🙂

[sidney]

put code in place of print_r($round);

as to more fields the more you put the longer the script
will take to brute force the combination as i have said
i only manage to get 10 fields to work before it took more than
30 seconds

i find this problem very interesting and will try to figur a better way as to how to figure the combinations if i come up with any thing ill let you know

[Forever_xxl]

I fink that you speak about data in table.
now in mysql i have:
id | name
And if i insert over field how coach it's not working
id | name | coach
i think that this script not read over fields. It's read only Id and name.

Not find where parse error in this line:
if(strpos($gval'BYE')===false)

[sidney]

if(strpos($gval'BYE')===false)
should be
if(strpos($gval,'BYE')===false)