how do you do this?

how do you get plain text from a mysql db an turn them into hyperlinks? here is the code i have so far
<?php
mysql_connect("host","username","pass");
mysql_select_db("dbname");
$query = "SELECT data,site FROM site where id=$id";
$result = MYSQL_QUERY($query);
$data = MYSQL_RESULT($result,0,"data");
print $data;
?>
any help would be great :)

you echo the html, and then the browser interprets it:

$variable='http://www.example.com';
echo '<a href="'.$variable.'">Link Text</a>';

mysql plays no relevant part.

ok thanks ill try your code

But if you wanted to to do a random site link eveytime just use a DB to store it all then just select the description and link.