Try...
while ($row = mysql_fetch_row($resultID))
>{
>print "<tr>";
>foreach ($row as $field)
>{
print "<td align=center><a href=$field>$field</a></td>";
>}
>print "</tr>";
>}
>print "</table>";
>mysql_close ($linkID);
I don't use print so I'm not sure about that, I use echo.
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-----Original Message-----
From: Rick Tucker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 1:58 PM
To: Larry Brown
Cc: [EMAIL PROTECTED]
Subject: RE: converting text to hypertext
Larry,
This is the code I'm using. I'm pretty new to PHP, so there may be a simple
solution within PHP of which I'm unaware. I just thought it could be done
from the MySQL side of things.
$resultID = mysql_query("SELECT * FROM ports", $linkID);
print "<table><tr><th>Port #</th>";
print "<th>Transport</th><th align=center>Application</th><th
align=center>RFC/Vendor's URL/MS KB article</th>";
while ($row = mysql_fetch_row($resultID))
{
print "<tr>";
foreach ($row as $field)
{
print "<td align=center>$field</td>";
}
print "</tr>";
}
print "</table>";
mysql_close ($linkID);
Thanks,
rick
-----Original Message-----
From: Larry Brown [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 10:13 AM
To: Rick Tucker
Subject: RE: converting text to hypertext
The question seems to me how are you outputting to html?
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-----Original Message-----
From: Rick Tucker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 11:34 AM
To: [EMAIL PROTECTED]
Subject: converting text to hypertext
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
