PHP-Code:
//TEAMNAMEN IN ARRAY SPEICHERN (KEY: ID DES TEAMS)
$result=mysql_query("SELECT id, name FROM ft_teams ORDER BY id");
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");
while($row=mysql_fetch_array($result)){
$spiele[$row['id']]=$teams[$row['team1']] . " - " . $teams[$row['team2']];
}
//TIPS IN TABELLE AUSGEBEN
echo "<table>";
echo "<tr>";
echo "<td>Spiel</td>";
echo "<td>Tip</td>";
echo "</tr>";
$result=mysql_query("SELECT game, tip FROM ft_gametips WHERE user='$details'");
while($row=mysql_fetch_array($result)){
echo "<tr>";
echo "<td>" . $spiele[$row['game']] . "</td>";
echo "<td>" . $row['tip'] . "</td>";
echo "</tr>";
}
echo "</table>";