From: Rick Tucker <[EMAIL PROTECTED]>
> Those addresses aren't being recognized as links when I output
> an html table from my queries.
[ snip ]
> I figured there would by a hypertext datatype of some sort...
Do you mean like this:
CREATE TABLE stuff (
link hypertext
);
INSERT INTO stuff (link) VALUES ('http://www.rbroom.com/');
SELECT * FROM stuff;
<a href="http://www.rbroom.com/";>http://www.rbroom.com/</a>
If so, then the answer is that there isn't such a data type. If you want a link, then
you'll have to make it yourself. I suggest making your column a varchar(). Then, you
~might~ get the data with a query like this:
SELECT CONCAT(CONCAT('<a href="', link, '">'), link, '</a>') FROM stuff;
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
sql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
