PHP outputting MYSQL results as links

[jester18]

Hello All,

 

I'm new to this forum completely new to PHP aswell. I'm wondering how to get PHP to output my results from MYSQL as links. I have a list of designers and and want the output to be a clickable list. Not sure how to achieve this?

 

heres my code:

 

<?PHP

 

$link = mysql_connect("******","******","");

mysql_select_db(******");

 

 

$query = "SELECT designer_name FROM designer WHERE left (designer_name,1) ='a'";

 

$results = mysql_query($query);

 

echo "<?xml version=\"1.0\"?>\n";

echo "<designers>\n";

 

while($line = mysql_fetch_assoc($results)) {

echo "<designer><![CDATA[ <br />" . $line["designer_name"] . "]]> </designer>\n";

}

 

echo "</designers>\n";

 

mysql_close($link);

 

?>

 

Many Thanks

 

[jester18]

anyone able to help a noob?