Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
another clasifications of tree and another colors for the rose, does anyone
knows how to retrieve them.
0100 - Rose tree
0101 - pink rose tree
0102 - red rose tree
0103 - rococo rose tree
0200 - generic tree
----- Original Message -----
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Rodney Broom" <[EMAIL PROTECTED]>
Cc: < >
Sent: Thursday, January 09, 2003 2:41 AM
Subject: Re: converting text to hypertext
> 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>') FROM
> stuff;
> >
> >
>
> But please remember, as was said earlier, to use the appropriate
> escaping functions for your language to make sure link contains no
> special HTML characters in the second instance and no URL characters in
> the first.
>
> --
> Michael T. Babcock
> C.T.O., FibreSpeed Ltd.
> http://www.fibrespeed.net/~mbabcock
>
>
>
>
> ---------------------------------------------------------------------
> 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
