Re: Adding hypertext data element into record ...

[Andrew Lietzow]

Thank you for your replies, Mos (and Sol):
So, is there there a way to store the following in a data record?
<a href="http://mydomain.com/photos/acoolpic.jpg";>My Cool Photo</a>

<>Mos Wrote:  RE:>>The code only becomes clickable when viewed from a 
browser so you need to retrieve the html string from the database and 
write it to an html page.  AND,

1) Use whatever language you like, PHP, Perl, running on a webserver so 
anyone can access it over the internet or intranet
2) Or if you only need to use it locally from your machine (and not 
share it without anyone else) then write an .exe program that either 
produces an html file that has that hyperlink in it and then pull up the 
browser to display the file, or build a browser into your .exe file and 
stream the html code to that.
---------------------------
RE: 1)  Is there no field type/data element type/column type that will 
allow a string to be treated as a hypertext link directly from MySQL?   
Seems like there are so many other field types that the MySQL folks 
might have created one that can generate a hypertext link on the fly by 
now.   It can be done within a wordprocessing document, and in an HTML 
document, so why not in a database? 

2) I try never to use .exe programs as this implies the need to use 
Windows and I try to stay 100% open systems, if at all possible.   

So, are you saying that if I am using phyMyAdmin and displaying records 
to the screen, and if one of the fields contains data like 
"http://mydomain.com/photos/mycoolpic.jpg"; that there is no way to make 
this "clickable" as a hypertext link?   If so, then I know that I have 
to write a php enabled (or perl enabled) page to accomplish this.  I've 
used Perl in the past but will try this with PHP.  I was simply trying 
to ascertain the state-of-the-art with MySQL... 

TIA for any definitive answers on this question.
Andrew L.
A Member of the GNU Generation