Re: [PHP] Recursive SQL Queries: Web Directory Categories

2001-05-09 Thread Philip Hallstrom
> - Original Message - > From: "Philip Hallstrom" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: 2001. május 8. 21:33 > Subject: Re: [PHP] Recursive SQL Queries: Web Directory Categories > > > > Also take a look at Joe Celko's &

Re: [PHP] Recursive SQL Queries: Web Directory Categories

2001-05-09 Thread Gyozo Papp
IL PROTECTED]> Sent: 2001. május 8. 21:33 Subject: Re: [PHP] Recursive SQL Queries: Web Directory Categories > Also take a look at Joe Celko's 'SQL for Smarties'. There's a whole > chapter on this. It gets kind if burly, but it's pretty cool. It's all &g

Re: [PHP] Recursive SQL Queries: Web Directory Categories

2001-05-08 Thread Philip Hallstrom
Also take a look at Joe Celko's 'SQL for Smarties'. There's a whole chapter on this. It gets kind if burly, but it's pretty cool. It's all done by converting your schema below into a tree structure... (no, i don't have any code since I've just read about it never done it :) -philip In articl

RE: [PHP] Recursive SQL Queries: Web Directory Categories

2001-05-08 Thread Krznaric Michael
James, Take a look at hierarchical queries in MS SQl. If I'm not mistaken, this is part of the SQL 99 standard and is implemented by many SQL 92 compliant database vendors. I know ORACLE and DB2 support it. I'm not sure if you already have but I would investigate this topic with MS SQL