PHP Tree Menu

how to build a Tree Menu

[seanjon]

Hi,

does somebody know a db structure in mysql as well as a SINGLE mysql query to get a Menu in form of a tree?

Example of such a tree menu:

cat1
--subcat1
----subsubcat1
----subsubcat2
----subsubcat3
--subcat2
cat2
cat3

salutations

[madmac]

try a google search for "modified pre-order tree transversal"

[seanjon]

thank you very much it works

[edited by: jatar_k at 5:42 pm (utc) on June 16, 2005]
[edit reason] no urls thanks [/edit]

[mincklerstraat]

madmac: thanks for the tip, I'll definitely be using that sometime.