Rodney Broom wrote:
If so, then the answer is that there isn't such a data type. If you want a link, then you'll have to make it yourself. I suggest making your column a varchar(). Then, you ~might~ get the data with a query like this:
SELECT CONCAT(CONCAT('a href=', link, ''), link, '/a')
Rick Tucker wrote:
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.
I think the point is more that there's no reason to have MySQL do it at
all since the
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
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
From: Rick Tucker [EMAIL PROTECTED]
Those addresses aren't being recognized as links when I output
an html table from my queries.
[ snip ]
I figured there would by a hypertext datatype of some sort...
Do you mean like this:
CREATE TABLE stuff (
link hypertext
);
INSERT INTO
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.
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
-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
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rick,
How are you pulling the data? PHP? Perl? ASP? HTML doesn't
automatically insert hyperlinks where it finds
http://www.somedomain.com. It has to be told that it is a link by the
A HREF=http://www.somedomain.com;SomeDomain/A
tag.
If
On 8 Jan 2003, at 12:08, Paul DuBois wrote:
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.
I think Paul meant to say you
Hi Rick!
You could also do something like the following (I'm assuming that the
http://www part isn't in $field already. . .).
=
print tr;
foreach ($row as $field)
{
print td align=centera
href=http://www.$field/;http://www.$field/td;
}
print /tr;
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
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
At 17:23 -0500 1/8/03, Keith C. Ivey wrote:
On 8 Jan 2003, at 12:08, Paul DuBois wrote:
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
15 matches
Mail list logo
