MySQL Text link in data

Anon

I've been searching the net trying to find a way of putting text with a hyperlink into records in a mysql table until I found the following:

Hyperlink : NOT SUPPORTED

The Hyperlink Datatype in Access is particular to access, and is not supported in MySQL. The nearest equivalent in MySQL would be to create a column with Datatype TEXT, which would accommodate the (up to) 2048 characters of the Hyperlink display text.

Can anyone think of a better way to achieve hyperlinked text?

thanks
Malc

[deleted]

No.
HTML is just text, nothing special at all.
A hyperlink is just a piece of text.
It's the browser that adds the "link" function to it.

If you don't want to store the full HTML of a link, you can also choose to store both the link and the link-text in seperate columns in the database.

Anon

Vincent

thanks for the help. How would I bring the link and the link-text togther when the record is displayed.

The database is a list of resteraunts and the link takes you to the menu if listed.

thanks
Malc

Anon

Is the menu link going to be the same structure on all pages? You can just put the URL in a field then you can have your code:

if ($menuurl) {
echo "<a href=\"$menuurl\">Menu</a>\n";
}

mdell

I am having a similar problem. On my display "printf" after a search one column needs to be linked to a URL in a new window. I tried the if($menu (myname of course)... and what I get is http://www.mywebsite.com/www.therewebsite.com We know that is not going to link to there site. Any suggestions?
Thanks
Matt