Display MYSQL query results as hyperlinks

[ken72]

Does anyone know how to display MYSQL query results as hyperlinks?

[bastien]

<?

//assume you can get data out of DB
echo "<table";
while ($rows=mysql_fetch_array($result)){
$link=$rows["link"];

echo "<tr><td><a href=\"$link\">$link</a></td></tr>";
}
echo "</table>";

?>