making a url in a database a hyperlink

[tmaunga]

i have got url fields in my database eg www.sharp.com ,i wish to extract the field from the database and make it a hyperlink

[Northern Flame]

you also need to store the text you want displayed in the link,

then you simply just connect to your database and run this:

 

<?php

/*
CONNECT TO DATABASE!
*/
$query = mysql_query("SELECT * FROM table");
while($row = mysql_fetch_array($query)){
echo '<a href="'.$row['url'].'">'.$row['text'].'</a><br>'."\n";
}
?>