I am creating site for greeting cards and need help desiging tables for DB Currently I have three tables.. 1) maincat which has following fields: maincatid (autoincrement) main_name (name of category) 2) subcat which has following fields: subcatid (autoincrement) maincatid sub_name (name of sub category)
Here's is my problem..each sub categories can also have sub categories (If main category is Birthday and Sub category is "His" then His can also have sub categories such as Brother,Uncle,Father etc.) Then I need to associates all these categories in cards table...which holds information about each card. To make it more complicated...each card can be displayed in multiple sub categories as well. How should I design all these? Any help will be greatly appreciated! sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php