creating a link from text in MySQL database

[martinb7]

Hi, does anyone know how to get text out of a database, loop for multiple records, then print on the screen?

Is there a hyperlink type in mysql?

$conn = mysql_connect($host, $user, $pass);
mysql_select_db($db, $conn);
$query = mysql_query("SELECT link, linkurl FROM links");


while(list($var) = mysql_fetch_row($query)) { //multiple with loop
echo $var(&quot;<a href=$linkurl>$link</a>&quot; ).&quot;<br>&quot;;
}
?>

What am I doing wrong??

Please help!

Martin

 

[pwesson]

Try this...

while ($r = mysql_fetch_array($query)) {
$link = $r["link"];
$link_url = $r["link_url"];

echo(&quot;<a href=\&quot;$link_url\&quot;>$link</a>&quot;
}