On Thu, Jan 20, 2011 at 2:40 PM, Jerry Schwartz <jerry@xxxxxxxxx> wrote: >>-----Original Message----- >>From: Dotan Cohen [mailto:dotancohen@xxxxxxxxx] >>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. No one argues with method of implementation(not that i explored the individual ideas), but with that available, you can hierarchy the concept of your db conceptualization. > > Regards, > > Jerry Schwartz > Global Information Incorporated > 195 Farmington Ave. > Farmington, CT 06032 > > 860.674.8796 / FAX: 860.674.8341 > E-mail: jerry@xxxxxxxxx > Web site: www.the-infoshop.com > > > >>-- >>Dotan Cohen >> >>http://gibberish.co.il >>http://what-is-what.com > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- The lawyer in me says argue...even if you're wrong. The scientist in me... says shut up, listen, and then argue. But the lawyer won on appeal, so now I have to argue due to a court order. Furthermore, if you could be a scientific celebrity, would you want einstein sitting around with you on saturday morning, while you're sitting in your undies, watching Underdog?...Or better yet, would Einstein want you to violate his Underdog time? Can you imagine Einstein sitting around in his underware? Thinking about the relativity between his pubic nardsac, and his Fruit of the Looms, while knocking a few Dorito's crumbs off his inner brilliant white thighs, and hailing E = mc**2, and licking the orangy, delicious, Doritoey crust that layered his genetically rippled fingertips? But then again, J. Edgar Hoover would want his pantyhose intertwined within the equation. However, I digress, momentarily. But Einstein gave freely, for humanity, not for gain, other than personal freedom. An equation that benefited all, and yet gain is a personal product. Also, if you can answer it, is gravity anymore than interplanetary static cling? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
