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
;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. > >Mike > > >-Original Message- >From: James Crowley [mailto:[EMAIL PROTECTED]] >Sent: Monday, May 07, 2001 1

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

2001-05-08 Thread Krznaric Michael
ic with MS SQL. Mike -Original Message- From: James Crowley [mailto:[EMAIL PROTECTED]] Sent: Monday, May 07, 2001 1:45 PM To: [EMAIL PROTECTED] Subject: [PHP] Recursive SQL Queries: Web Directory Categories Hi, I have a web directory which allows sub-categories to an unlimited leve

[PHP] Recursive SQL Queries: Web Directory Categories

2001-05-07 Thread James Crowley
Hi, I have a web directory which allows sub-categories to an unlimited level. This is done with a categories table, and assigning a parentid to each... For example ID ParentIDName 10 Products 21 Sub-Category of Products (Level 1) 31 Another