Displaying a clickable playername

[Gubbins]

I am going wrong somewhere with the mysql_query, can someone please put me straight?

 

$playername = mysql_query("SELECT * FROM `players` WHERE `playername` LIMIT 1");
while($f = mysql_fetch_array($playername)){

$txt = str_replace("[player]", "<a href='profile.php?player={$f['playername']}'>{$f['playername']}>", $txt);
$txt = str_replace("[/player]", "</a>", $txt);
}

[premiso]

I am taking that you want to fetch all players:

 

$playername = mysql_query("SELECT playername FROM `players` LIMIT 1");

 

Should do just fine.

[oni-kun]

Yes, there is no need to have specifics unless you need to fit a variable in, you can select the columb itself.