RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist
| From: | Jerry Schwartz | Date: | Thu, 20 Jan 2011 19:40:05 +0000 |
| Subject: | RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-310916@lists.php.net to get a copy of this message | ||
>-----Original Message-----
>From: Dotan Cohen [mailto:dotancohen@gmail.com]
>Sent: Thursday, January 20, 2011 11:25 AM
>To: Jerry Schwartz
>Cc: mysql.; php-general.
>Subject: Re: Organisational question: surely someone has implemented many
>Boolean values (tags) and a solution exist
>
>
>> As for setting up a hierarchy, that's trickier. One way to handle that is
>> to
>> work like libraries do: 10 is "fiction", 10.05 is "crime novels",
>> 10.05.07
>> is
>> "British authors", and so forth. Your
tags table
>> then looks like
>>
>
>Thanks. I prefer the "parent tag" field, though, I feel that it is
>more flexible.
>
>
[JS] I disagree. The method I proposed can be extended to any depth, and any
leaf or branch can be retrieved with a single query.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com
>--
>Dotan Cohen
>
>http://gibberish.co.il
>http://what-is-what.com