[Resolved] links in query result

[gamermx]

I have a table in my db that stores the information about the players in a league.
When i query the db' table i need that every player showed in the result list have a link to the respective information.

sorry about my english, its not my native languaje.

[TheDefender]

Do you have any code written so far or are you asking someone to write the code for you? If you've started writing the code, then post what you have, and we'll help you fix it. If you haven't written anything yet, then I recommend you take a look in the PHP and MySQL manuals and search these forums for info because what you're asking is pretty basic functionality in php and MySQL... (Querying databases and displaying the result set)

[gamermx]

i wrote this:

<?php

  $result = mysql_query("select pl_name from player where pl_team like '$team' ");
  while($row = mysql_fetch_array($result)) 
	{printf("<tr><td>&nbsp;%s&nbsp;%s</td></tr>", $row["pl_name"]); }   

?>

and display this:

Charles Barkley
Michael Jordan
...
...
etc

very simple but it works. Now, what i need is that each name have a link to his own info, stored in the db, so i can press on the name and take me to the info.

i hope u can fully understand what i am asking

[TheDefender]

Something like this... (assuming you have a unique identifier like a player's ID or something like that...) Need more details like table structure to be able to help you out any further.

<?php 
$result = mysql_query("select * from player where pl_team like '$team' "); 
while($row = mysql_fetch_array($result)) {
    echo "<tr><td><a href=\"detailspage.php?pid=".$row['pl_id']."\">". $row['pl_name']."</a></td></tr>";
}
?>

[gamermx]

It was really helpful. Thank u.