Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT(sHomeTeam) AS 'sHomeTeam' FROM MatchDB WHERE sRound LIKE 'Group %'
- while($row = $sql->fetch_assoc()){
- $team = $row['sHomeTeam'];
- $arr = array();
- SELECT sRound,iCupID FROM MatchDB WHERE sHomeTeam = '$team' AND sRound LIKE 'Group %' GROUP BY sRound,iCupID ORDER BY iCupID
- while($row2 = $sql2->fetch_assoc()){
- $cup = $row2['iCupID'];
- $round = $row2['sRound'];
- SELECT DISTINCT(sHomeTeam) AS 'team' FROM MatchDB WHERE sHomeTeam != '$team' AND iCupID = $cup AND sRound = '$round' ORDER BY sHomeTeam
- $temparr = array();
- while($row3 = $sql3->fetch_assoc()){
- $temparr[] = $row3['team'];
- }
- $arr[] = array('cup'=>$cup,'teams'=>$temparr);
- }
- for($i = 0;$i < count($arr)-1;$i++){
- for($j = $i+1;$j < count($arr);$j++){
- $count = 0;
- for($k = 0; $k < 3; $k++){
- for($l=0; $; < 3; $l++){
- if($arr[$i]['teams'][$k] == $arr[$j]['teams'][$l])
- $count++;
- }
- }
- if($count == 3)
- echo $team . " " . $arr[$i]['cup'] . " " . $arr[$j]['cup'] . "<br>";
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement