OK i got most of it worked out myself but i stll need some help, 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