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

2001-05-09 Thread Gyozo Papp
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 done by converting your schema below into a tree structure... (no, i don't have

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

2001-05-09 Thread 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 'SQL for Smarties'. There's a whole chapter on this. It gets kind if burly, but it's pretty cool. It's all done

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

2001-05-08 Thread Krznaric Michael
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 level

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

2001-05-08 Thread Philip Hallstrom
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:45 PM To: [EMAIL PROTECTED] Subject: [PHP] Recursive SQL Queries: Web Directory Categories Hi, I have a web directory

[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