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