Dynamic creation of categories (MySQL/PHP)

[slain84]

Hi everyone,

I am going to program an ads page. Every ad belongs to a category. An example:

--> Cars --> Porsche --> Cayenne
--> DVDs --> Action-Movies --> >18 years --> Lethal Weapon 3

Thus, there might be several sub-categories. This is no problem at all, but these sub-categories should be created by the admin later dynamically. He should be able to click through the categories and add a sub-category to "Cayenne" for example.

I have now the problem that I do not really know how to set up the MySQL database and how a script should look like so that the added categories are displayed.

I was thinking about adding fields to the category table in the database. That means that cat01 stands for the first sub-category, cat02 for the second and so on. If the admin adds a new, a new cat03 must be created. I do not how to implement that in my PHP script though.

Can anyone help?

Thanks,

Dominik

[manmadareddy]

you just need to have CategoryID,CategoryName,ParentID,Level,status
I hope these fields are sufficient.

[gerkintrigg]

yeah, provoded that you have parentID (as suggested above) you can state what level the category is at. If the parent id field is empty, your system can assume it's a top-level category and you can go from there.

Thanks for the suggestion... I think I'll do it that way too... ;o)