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
[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
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
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
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
5 matches
Mail list logo