List: | General Discussion | « Previous MessageNext Message » | |
From: | Dotan Cohen | Date: | January 20 2011 7:59pm |
Subject: | Re: [PHP] RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist | ||
View as plain text |
On Thu, Jan 20, 2011 at 21:40, Jerry Schwartz <jerry@stripped> wrote: >>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. > I suppose for retrievals this structure has advantages, but unless MySQL has a ++ operator (or better yet, one that adds or subtracts 2 from an int) then it looks to be a pain to add nodes. But I will play with the idea. Maybe after I write the code (I'm saving that for tomorrow) I'll see it differently. Thanks. -- Dotan Cohen http://gibberish.co.il http://what-is-what.com