>From: Dotan Cohen [mailto:dotancohen@stripped]
>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
>> work like libraries do: 10 is "fiction", 10.05 is "crime novels", 10.05.07
>> "British authors", and so forth. Your `tags` table then looks like
>Thanks. I prefer the "parent tag" field, though, I feel that it is
[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.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com