On Wed, Jan 08, 2003 at 08:34:25AM -0800, Rick Tucker wrote:
> I just imported a .csv file and one of the columns of data was websites
> addresses. Those addresses aren't being recognized as links when I output
> an html table from my queries. I'm scratching me head on how to make the
> conversion. I figured there would by a hypertext datatype of some sort, but
> I can't find any information regarding this issue. If someone could point me
> in the right direction, I would appreciate it.
Good Day Rick!
There is no hypertext/hyperlink data type and I do not know of any plans for
one.
A simple bit of shell scripting like:
mysql -e "SELECT something FROM somewhere" -H |\
sed -e 's/http:\/\/[^ ]\+/<a href="&">&<\/a>/'
should replace all of the valid http URLs in your HTML tables with anchors.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
MySQL Training: London, January 13-17, 2003
Visit http://mysql.com/training for more information
"While we are postponing, life speeds by." --Lucius Annaeus Seneca
---------------------------------------------------------------------
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
