I've looked all over the mysql.org website, for data element/column types, and find no reference to storing data as a link to an html document or blob. I am thinking this can be done but need help with syntax.
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>
I can store the data, but obviously, since the display of records following a query simply displays the text, which is not hypertext enabled, there is no means to click on the data and have anything happen. IOW, is there a way to hypertext enable data in a mysql data record?
TIA, Andrew L. A member of the gnu generation
Andrew,
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.
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.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
![http://mydomain.com/photos/acoolpic.jpg"](http://mydomain.com/photos/acoolpic.jpg"){kind=link}