Re: Programming User-Customized Categories ??
| From: | Matt Matijevich | Date: | Fri, 18 Jun 2004 20:48:23 +0000 |
| Subject: | Re: Programming User-Customized Categories ?? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-188614@lists.php.net to get a copy of this message | ||
[snip]
I need to allow users to define the types of Main Categories they want,
and
to also define whether or not those Main Categories will have Sub
Categories, which they can also define.
[/snip]
if I follow you correctly, I would do it like this
users table
user_id primary key
name
etc... not sure what other fields you have.
category table
category_id primary key
user_id foreign key from users table. users can have many categories
name
etc...
sub_category table
sub_category_id primary key
category_id foreign key from category table. categories can have many
sub_categories
name
etc...