[SOLVED] Making MySQL values into links?

[spiceydog]

So the subject doesn't quite say it all... I have a value in my MySQL table called "links" and within that value you will see something like this:

http://www.google.com http://www.ebay.com/ http://www.phpfreaks.com/ etc.

 

Now when I echo that I want it to look something like this:

<a href="http://www.google.com">http://www.google.com</a><a href="http://www.ebay.com/">http://www.ebay.com/</a><a href="http://www.phpfreaks.com/">http://www.ebay.com/</a>

 

Is there anyway that can be done?

[Xurion]

Try this:

 

<?php

$result = mysql_query("SELECT addresses FROM addresses");
$row = mysql_fetch_assoc($result);
$addresses = split(' ', $row['addresses']);

foreach($addresses as $value){
echo '<a href="'.$value.'">'.$value.'</a>';
}

?>

 

This takes the string and splits it into an array at every space character.

[fenway]

You shouldn't store arrays in a single DB field.

[spiceydog]

thank you xurion!!!

 

fenway: if i were better at designing mysql tables im sure i would have thought of that but its 2 late now!! ahhh... lol