Replacing With Unique Link

[WLC135]

I'm trying to create a function that will replace names found in an article with links to more information about that person.

I would like to be able to call the names from a MySQL DB along with the unique ID that goes with each name and then replace the name in the article with the proper link

This is the code I have so far, it works to create a link, but not with the proper id, however I am not very familiar with the foreach() function. Any help would be greatly appreciated.

function name_link($message)
{

$i = 0;
$q = mysql_query("select first_name, last_name, id from players") or die(mysql_error());
while($a = mysql_fetch_array($q, MYSQL_BOTH))
{

	$player_names[$i] = "$a[first_name] $a[last_name]";

	$i++;

}


foreach($player_names as $player_name)
{
	$link = "<a href=\"\">$player_names</a>";
	$message = str_replace($player_name, $link, $message);
}

return $message;
}

[bj_]

How were you planning on using the ID? What's it for?
Also, it is good code to use quotes with you associative arrays:
array['foo'].

[bj_]

How were you planning on using the ID? What's it for?

[diego25]

If you need the ID, then you need to store that in the $players_names array, too, right?

while($a = mysql_fetch_array($q, MYSQL_BOTH))

{



    $player_names[$i][0] = "$a[first_name] $a[last_name]";
    $player_names[$i][1] = $a['id'];


    $i++;



}





foreach($player_names as $player_name)

{

    $link = "<a href=\"detail.php?id=$player_name[1]\">$player_name[0]</a>";

    $message = str_replace($player_name, $link, $message);

}

Diego

[WLC135]

Thanks for the help. The only thing that needed to be changed from the snippet above if anyone else takes that is this:

    $message = str_replace($player_name, $link, $message);
    //Wont work, must use the array position as well. see below

    $message = str_replace($player_name[0], $link, $message);

Thanks for the help, I had been looking at that for some time.