Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. SELECT DISTINCT(sHomeTeam) AS 'sHomeTeam' FROM MatchDB WHERE sRound LIKE 'Group %'
  2. while($row = $sql->fetch_assoc()){
  3. $team = $row['sHomeTeam'];
  4. $arr = array();
  5. SELECT sRound,iCupID FROM MatchDB WHERE sHomeTeam = '$team' AND sRound LIKE 'Group %' GROUP BY sRound,iCupID ORDER BY iCupID
  6. while($row2 = $sql2->fetch_assoc()){
  7. $cup = $row2['iCupID'];
  8. $round = $row2['sRound'];
  9. SELECT DISTINCT(sHomeTeam) AS 'team' FROM MatchDB WHERE sHomeTeam != '$team' AND iCupID = $cup AND sRound = '$round' ORDER BY sHomeTeam
  10. $temparr = array();
  11. while($row3 = $sql3->fetch_assoc()){
  12. $temparr[] = $row3['team'];
  13. }
  14. $arr[] = array('cup'=>$cup,'teams'=>$temparr);
  15. }
  16. for($i = 0;$i < count($arr)-1;$i++){
  17. for($j = $i+1;$j < count($arr);$j++){
  18. $count = 0;
  19. for($k = 0; $k < 3; $k++){
  20. for($l=0; $; < 3; $l++){
  21. if($arr[$i]['teams'][$k] == $arr[$j]['teams'][$l])
  22. $count++;
  23. }
  24. }
  25. if($count == 3)
  26. echo $team . " " . $arr[$i]['cup'] . " " . $arr[$j]['cup'] . "<br>";
  27. }
  28. }
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement