On 1/8/03 8:34 AM, "Rick Tucker" <[EMAIL PROTECTED]> 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. > > Thanks, > > rick How about : <a href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]</a> Thus if you just store: [EMAIL PROTECTED] in your database then you need to retrieve it with the CONCAT function SELECT CONCAT('<a href=\"' ,email, '\'">', email, '</a>') FROM mytable; And 'email' is the name of the column that stores your email address. <http://www.mysql.com/doc/en/String_functions.html> Best/h --------------------------------------------------------------------- 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
