>-----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.
Regards, 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 > >http://gibberish.co.il >http://what-is-what.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
