Jump to content


This topic is now archived and is closed to further replies.


Dynamic creation of categories (MySQL/PHP)

Recommended Posts

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?



Share this post

Link to post
Share on other sites
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)

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.