URLs and TEXT fields

Anon

Ok, I have a database with the following text field...

"This event has been going on for the past 20 years. For more information, visit www.domainname.com or call 212.555.1234."

Well, when I print this field on a php page, I'm interested in making all urls a link. So, I'm looking to substitute any...

www.domainname.com OR http://www.domainname.com

with

<a href="http://www.domainname.com/" target="_blank">www.domainname.com</a>

In short, I'm trying to turn the above text field into:

"This event has been going on for the past 20 years. For more information, visit <a href="http://www.domainname.com/" target="_blank">www.domainname.com</a> or call 212.555.1234."

How do you go about changing elements inside a text field? I know that I could put the html in the text field, but the administrator of the database will not want to deal with that. Any ideas?

Jabbamonkey

mrskhris

Jabbamonkey wrote:

How do you go about changing elements inside a text field? I know that I could put the html in the text field, but the administrator of the database will not want to deal with that. Any ideas?

Why? HTML is not some magic staff - it's simly text symbols, nothing else. Otheriwise you stack with eregs for turning URLs to HREFs on-the-fly, and that's no easy task (just think of a possibility of periods/commas/whatever at the end if URL).