passing var in echo statment

[daolson]

what i'm trying to do is pas the var called name somehow in this echo statment, I'm just not having much luck.

echo("</td><td width=200>");
echo ("<a href=\"" . mysql_result($sqlData, $i, "link") . "\">" . mysql_result($sqlData, $i, "name") . " </a>");

darin

[Frederick]

you can't echo a query.

$sql = mysql_query("SELECT * FROM tablename WHERE id=$id")
or die(mysql_error());

while ($row = mysql_fetch_array($sql)) {
    echo "<a href=\"".$row["link"]."\">".$row["name"]."</a>";
}