Ok, jetzt gehts, nochmals danke. Hier der korrekte Code
PHP-Code:
<?
//TEAMNAMEN IN ARRAY SPEICHERN (KEY: ID DES TEAMS)
$result=mysql_query("SELECT id, name FROM ft_teams ORDER BY id",$conn);
while($row=mysql_fetch_array($result)){
$teams[$row['id']]=$row['name'];
}
//SPIELE IN ARRAY SPEICHERN (KEY: ID DES SPIELS)
$result=mysql_query("SELECT id, team1, team2 FROM ft_games ORDER BY id",$conn);
while($row=mysql_fetch_array($result)){
$spiele[$row['id']]=$teams[$row['team1']] . " - " . $teams[$row['team2']];
}
echo "<table>";
echo "<tr>";
echo "<td>Spiel</td>";
echo "<td>Tip</td>";
echo "</tr>";
//TIPS IN TABELLE AUSGEBEN
$result=mysql_query("SELECT game, tip FROM ft_gametips WHERE user='$details'", $conn);
while($row=mysql_fetch_array($result)){
echo "<tr>";
echo "<td>" . $spiele[$row['game']] . "</td>";
echo "<td>" . $row['tip'] . "</td>";
echo "</tr>";
}
echo "</table>";
?>