Need help with returning a db querry as a link

HI, I have a question about returning a database querry as a link, I have a DB with 3 colums, one of them in named ID. I have it so that the data returned is a link, and it has the link and adds the number from the id column on the end. Now my question, how can I make it so that it just returns the value of the db as a link WITHOUT putting the name of the link? By this I mean lets say on of the filed has the name John in it, the I would like the name John to show up on the page, as a link. Here is my code so that maybe It will clarify what i am saying,

{
echo "<TR><TD>".$myrow["name"]." ".$myrow["score"]."<TD>".$myrow["team"];
echo "<TD><a href="team_info.php?id=".$myrow[id]."">Info</a>";
}

now notice it will return a link on the end that says Info that links to the team_info page. BUT I want to do away with that and just have the name be the link to the team_info page, but since its a loop i can't just specify what the name is like i am doing now.

I hope I explained that ok, i have seen this done but can't figure out how to do it

So you want the name to be where text "info" is now? That's too easy: