Administrative tool for creating categories and subcat.

[traveller]

Hello,

I have created a site and now it is time to add categories and subucategories etc. I want the user to be able to do that. How can I do it?

I've searched around and found that I should have a table for cat's and subcat's like this

cat_id ->autoincrement, int, pkey

title ->varchar or text

parent_id->int

product_id->integer (foreign key??)

 

and a relevant table for products

 

 

however I cannot figure out (I am a newbie  :-\) how to insert a subcategory and furthermore how to display them in a tree menu (do I need javascript?).

 

I would appreciate an answer or a link to a tutorial.

 

Thank you,