Help....I hope I word this correctly that someone will understand and be able to help me. I have a database of information on wrestling teams. On one of the pages that I have created I am listing all the teams by division and want to create a link to an information page for each team. On the particular page I am talking about, I am extracting the team name and location from the database and displaying it. I want to make the team name linkable to the info page using another field from my database for that html page.
eg. table: ID, TeamName, Teamhtml, MatchLoc, etc...
The code (non-php as it is today):
<tr>
<td bgcolor=blue align=center>
<a href=NazWildInfo.html>
<font color=white size=4>
TEAM A</font></a>
</td>
<td bgcolor=blue align=center>
<font color=white size=4>
TEAM A LOC</font>
</td>
</tr>
My current php code for this:
<tr>
<td bgcolor=blue align=center>
<a href=INFONAME from DB>";
<font color=white size=4>
<?
$name = $sql->QueryItem("select TeamName from TeamInfo where ID = 1");
echo("$name\n");
?></font></a>
</td>
<td bgcolor=blue align=center>
<font color=white size=4>
<?
$loc = $sql->QueryItem("select MatchLoc from TeamInfo where ID = 1");
echo("$loc\n");
?></font></a>
</td>
</tr>
If INFONAME is a field on my table how do I code php for my <A HREF> statement to work properly??? Any help is appreciated...Thanks!!!!
