query($sql);
$info = $result->fetch_assoc();
if (!$result || $info == null){
echo "Ungültige Team ID";
return;
}
$sql = "SELECT * FROM matches WHERE team_id =".$id." ORDER BY date";
$result = $conn->query($sql);
if ($result->num_rows < 1){return;}
$games = array();
while($row = $result->fetch_assoc()){
$games[]=$row;
}
//$sql = "SELECT s.*, n.display FROM standings s, (SELECT group_id,display,standings_url,league from nuliga WHERE team_id = ".$id.") n WHERE s.group_id = n.group_id ORDER BY pos";
$sql = "SELECT s.* FROM standings s WHERE s.group_id = ".$info["group_id"]." ORDER BY pos";
$result = $conn->query($sql);
$standings = array();
while($row = $result->fetch_assoc()){
$standings[]=$row;
}
$conn->close();
?>
" target="_blank">nuLiga