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(''), link, '') FROM stuff;
But ple
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 logic
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 tag. Don't forget
to URL-encode it for use in the attribute, and HTML-encode it for
use in th
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
> conversio
or debug the code or look for security flaws, or put logic in place
for poorly formed URLs, you should be able to handle that.
-Original Message-
From: Rick Tucker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 10:58 AM
To: Larry Brown
Cc: [EMAIL PROTECTED]
Subject: RE
Hi Rick!
You could also do something like the following (I'm assuming that the
http://www part isn't in $field already. . .).
=
print "";
foreach ($row as $field)
{
print "http://www.$field/";>http://www.$field";
}
print "";
=
Cheers!
-warre
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 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 yo
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 conversio
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
> conversio
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'
essage-
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-
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
> conversio
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 I
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
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 b
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
16 matches
Mail list logo