Heres the query used to get game scores.
SELECT team, score, opponent, score1
FROM boxscore
ORDER BY id DESC
Heres how its displayed in table.
<table border="0">
<?php do { ?>
<tr>
<td><div align="left" class="darkorange style5"><span class="style5"><?php echo $row_ga['team']; ?></a></span></div></td>
<td><span class="style5 style5"><?php echo $row_ga['score']; ?></span></td>
<td><span class="style5 style5"><?php echo $row_ga['opponent']; ?></span></td>
<td><div align="right" class="darkorange style5"><span class="style5"><?php echo $row_ga['score1']; ?></span></div></td>
</tr>
<?php } while ($row_ga = mysql_fetch_assoc($ga)); ?>
</table>
Now i want it to link to this boxscores.php?id=$game_id
Game IDs come from
SELECT game_id, team1, team2
FROM game
Now it has to make the link based on the team or opponents team name that is listed. Heres an example.
http://www.mfl.v4host.com/nto/teams.php?id=5&team=dallas
If you go down you see Minnesota 92 Dallas 61
That will not always be Minnesota but aslong as ?team=dallas it will always have dallas in one of the columns team or opponent.
