Hi,
can someone suggest the best way to perform a query that
extract from a category table all the structure, like a filesystem?
For example, I've a table of categorie like this:
ID namedescr ID_parent
and I've assigned -1 to the root category.
I'd like to draw a directory-like
Hi,
A simple way is to make a recursive search by starting from the root,
and collecting all ID's from each layer. You need only one query per
layer, not one per node.
It looks like this :
- start from the desired directory :
SELECT * FROM table WHERE id_parent IN (8)
- say it returns
]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Wakan [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: how to retrieve a hierarchical structure
Hi,
can someone suggest the best way to perform a query that
extract from