Categories tree

[prijshost]

I have 2 tables:

Table categories: fields: categories_id, parent_id
Table categories description: fields: categories_id, categories_name.

Is there a way to display these in a tree? for example

Main cat 1
|->subcat 1
|->subcat 2
Main cat 2
| subcat 3

I don't want to use javascript, because this takes too long to generate te tree.

I HAVE to use 2 tables. I can't use one table.

Help appreciated.

 

[sleipnir214]

I assume that you have a value which can appear in categories.parent_id which indicates the category has no parent. I further assume that value is 0 and that category IDs start at 1.

You'll have to do this with two queries in nested loops.

First, perform a query to fetch those category IDs and names that nave no parents.

Then loop through that query's result set, for each category creating programmatically another query to fetch that category's children.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[prijshost]

Thanks, worked great !!