Getting stored links from database and presenting as hyperlink

[abel122]

Hello. Can someone please help me with this. Let's say I have a database of links and description of those links. How can I use php to display those links as hyperlinks?

Ex. http://www.abcd.com is in my datatbase with a description of 'good site'. I want to pull it from the database but I want to show it in the browser as 'good site', with 'good site' taking me to www.abcd.com when pressed.

Any help will be greatly appreciated.

Abel

[NevetsRetxab]

Get the data from the database
put it in a html hyperlink.

<?
mysql_connect("localhost","yourdbuser","Yourdbpass");
mysql_select_db("Yourdatabase");
$result=mysql_query("SELECT * FROM yourtable");
// assuming that the url is column 0 and comment is column 1
$data=mysql_fetch_array($result);
echo "<a href='$data[0]'>$data[1]</a>";
?>