Creating categories and sub-categories

DBA

Hi,

Did anyone happen to create a PHP script(s) to able to create categories and sub-categories? MySQL is the database back end in this case. Any comments is appreciated. Thanks in advance.

sijis

are you looking to create one yourself or something that is already done?

here's an idea for your.

tblCategories

| catID | subCatID | catName |

| 1 | 0 | Section 1 |
| 2 | 0 | Section 2 |
| 3 | 1 | Sub Cat of Section 1 |
| 4 | 2 | Sub Cat of Section 2

tblCategories is the name of the table.
catID is the autonumber
subcatID is referencing to another section, but if it equals 0, then its the main section.

hope that helps.

DBA

Thanks, sijis.

I total understand the idea. Also I have already the table created,

+-----------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+----------------+
| cat_id | int(11) | | PRI | NULL | auto_increment |
| parent_id | int(11) | | | 0 | |
| cat_name | tinytext | | | | |
+-----------+----------+------+-----+---------+----------------+

The only thing I am confused is how do you set up a PHP script to automatically retrieve the categories structure from the table to show something liek that below, i.e.,

Thanks again.