list of all categories and subcategories

[thompson]

hi,

i´m looking after a list of all categories and subcats in alphabetical order.

to list the cats it is not the problem, but to list the subcats to the cats it is difficult for me.

ex.

cat a
-subcat a
-subcat b
-subcat c

cat b
-subcat d
-subcat e

anyone who knows how the sql statement therefore is ?

thanks.

[thompson]

no ideas ?

[mdvaldosta]

I did mine by hand.

[thompson]

i must go easier. ;)

[Nobody]

I'm also looking for this in order to use it as a sitemap.