[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... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
