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
Sorry I was to fast: (mailto: was missing, but you probably figured that by
yourself).
SELECT CONCAT('<a href=\"mailto:' ,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
