>-----Original Message-----
>From: Dotan Cohen [mailto:dotanco...@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.


Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com

>Dotan Cohen

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to