Help with hyperlink data type!

[anon]

Hello, I have created my database and I want it to have a row that, when retrieved, shows the result as an hyperlink. I am wondering if this is something that is done with PHP, but I would just like to know if there is a specific data set that displays  as an hyperlink.

 

Your help appreciated. ???

[Barand]

MySQL has no hyperlink column type.

 

Store URL in a varchar column.

 

<?php
$sql = "SELECT name, url FROM table";
$res = mysql_query($sql) or die (mysql_error()."<p>$sql</p>");

while (list($name, $url) = mysql_fetch_row($res))
{

    echo "<a href='$url'>$name </a> </br/>";
}

?>