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