At 8:34 -0800 1/8/03, 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.
You must perform the conversion yourself, displaying the URL both as the href atttribute and body text of an <a> tag. Don't forget to URL-encode it for use in the attribute, and HTML-encode it for use in the body text.
Examples in Perl, PHP, Python, and JSP are available at: http://www.kitebird.com/mysql-cookbook/ Get the recipes distribution, check the apache/links and tomcat/mcb directories for the examples. Mmm, that's two book plugs in a day, I'd better cool off for a while. :-)
Thanks, rick
--------------------------------------------------------------------- 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
