Spielergebnis eingeben
Spiel:
prepare("SELECT m.id, t1.name AS home_team, t2.name AS away_team FROM matches m JOIN teams t1 ON m.home_team_id = t1.id JOIN teams t2 ON m.away_team_id = t2.id WHERE m.played = FALSE"); $stmt->execute(); $result = $stmt->get_result(); while($row = $result->fetch_assoc()){ echo "
{$row['home_team']} vs {$row['away_team']}
"; } $stmt->close(); ?>
Heim-Punkte:
Auswärts-Punkte:
Ergebnis speichern