Links in text data

[Anon]

I would like to set up a MySql database to hold content for our web site. I would also like to have hyperlinks within the content.

Has somebody already developed code to enable the text output to include hyperlinks?

[Anon]

That's easy.

Create a table with a text or blob field (a var char field would work, but would have a
smaller limit on length, which might cause
a problem), and put your data in that field.

Simply include the
<a href="...">text</a> in the
data, and when you print out the field,
it's included in the resulting page.

[Anon]

Super... thanx for your answer.

[Anon]

Hope this helps...

function make_clickable($text)
{
$ret = eregi_replace( "([[:alnum:]]+)://([^{[:space:]])([[:alnum:]#?/&=])",} "<a href=\"\1://\2\3\" target=\"_blank\" target=\"_new\">\1://\2\3</a>", $text);
$ret = eregi_replace( "(([a-z0-9_]|\-|\.)+@([^[:space:]])([[:alnum:]-]))", "<a href=\"mailto:\1\" target=\"_new\">\1</a>", $ret);
return($ret);
}