Insert link from mysql database into html

[sandin]

In my mysql database, I have web addresses which I want to bring into an html page.

<a href="url from mysql database">Link text</a>

How do I do this?

[Dan Grossman]

<?php

mysql_connect('hostname', 'username', 'password');
mysql_select_db('databasename');

$query = "SELECT url FROM table";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {
 
  echo '<a href="' . $row['url'] . '">Link Text</a> ';

}

?>

[sandin]

Thanks a lot.