1:
2:
3:
4:
5:
6:
7:
|
$sql = SELECT b.spieltag, b.heimpunkte, b.gastpunkte, b.spiele_heim, b.spiele_gast, b.datum, cc.teamname as heimteam,dd.teamname as gastteam FROM teams a
LEFT JOIN spiele b ON a.ID = b.heimteam
INNER JOIN teams cc ON b.heimteam = cc.ID
INNER JOIN teams dd ON b.gastteam = dd.ID
INNER JOIN ligen c ON a.liga_id = '$liga'
WHERE b.datum NOT LIKE '0000-00-00'
GROUP BY b.ID ORDER BY spieltag ASC, b.datum ASC " |