RE: [PHP] RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

2011-01-20 Thread Jerry Schwartz
>> [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) th

Re: [PHP] RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

2011-01-20 Thread Dotan Cohen
On Thu, Jan 20, 2011 at 21:40, Jerry Schwartz 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 re

Re: [PHP] RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

2011-01-20 Thread David Hutto
On Thu, Jan 20, 2011 at 2:40 PM, Jerry Schwartz wrote: >>-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 m