(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
so
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 chil
