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
(for filter: query,sql,mysql,table)
I've done this a few times, I mostly do category systems and there
is no reason to list all the categories at one time, so I usually
have a parent id to work with in order to get all the sub
categoreis from the DB. However, I have done one where I did want