link problem

[code:1:0971e54d64]<?
mysql_connect("localhost","username ","pass");
mysql_select_db("test");

$search=$_GET["search"];
$result = mysql_query("SELECT * FROM cheaterlist WHERE pcid LIKE '%$search%'");

while($r=mysql_fetch_array($result))
{

$pcid=$r["pcid"];
$playername=$r["playername"];
$statlink=$r["statlink"];

echo "<table border=1 width=100% align=center><tr><td align=left WIDTH=14%>$pcid</td><td align=left WIDTH=10%>$playername</td><td align=left WIDTH=80%>$statlink</td></tr></table>";
}
?>[/code:1:0971e54d64]

this is the code in my results.php but my problem is in this part :

[code:1:0971e54d64]echo "<table border=1 width=100% align=center><tr><td align=left WIDTH=14%>$pcid</td><td align=left WIDTH=10%>$playername</td><td align=left WIDTH=80%>$statlink</td></tr></table>";[/code:1:0971e54d64]

how do i make [code:1:0971e54d64]<td align=left WIDTH=80%>$statlink</td>[/code:1:0971e54d64] turn into a link to the players stat page? if i put <a href="$statlink">click here</a> it makes my result page not return anything just be a plain white page... i think its because of the " in it but i cant seem to figure out a way around this :cry:

this is for the return search of a mysql database if that helps at all...

[quote:352c415213="bw"][code:1:352c415213]<?
mysql_connect("localhost","username ","pass");
mysql_select_db("test");

$search=$_GET["search"];
$result = mysql_query("SELECT * FROM cheaterlist WHERE pcid LIKE '%$search%'");

while($r=mysql_fetch_array($result))
{

$pcid=$r["pcid"];
$playername=$r["playername"];
$statlink=$r["statlink"];

echo "<table border=1 width=100% align=center><tr><td align=left WIDTH=14%>$pcid</td><td align=left WIDTH=10%>$playername</td><td align=left WIDTH=80%>$statlink</td></tr></table>";
}
?>[/code:1:352c415213]

this is the code in my results.php but my problem is in this part :

[code:1:352c415213]echo "<table border=1 width=100% align=center><tr><td align=left WIDTH=14%>$pcid</td><td align=left WIDTH=10%>$playername</td><td align=left WIDTH=80%>$statlink</td></tr></table>";[/code:1:352c415213]

how do i make [code:1:352c415213]<td align=left WIDTH=80%>$statlink</td>[/code:1:352c415213] turn into a link to the players stat page? if i put <a href="$statlink">click here</a> it makes my result page not return anything just be a plain white page... i think its because of the " in it but i cant seem to figure out a way around this :cry:

this is for the return search of a mysql database if that helps at all...[/quote:352c415213]


make it <a href=\"$statlink\">$statlink</a>