Forums

PHP

This topic is locked

Add product/ Dreamweaver/ many to many relation

Posted 13 Aug 2008 20:07:59
1
has voted
13 Aug 2008 20:07:59 agatqua a posted:
How then can I create an "add product" page in dreamweaver? I'll have categories and subcategories and I'd like the field look like this:


category:

writing instruments (category)
-pens (subcategory)
-pencils (subcategory)

recycled products (category)
-recycled pens (subcategory)
-recycled sticky notes (subcategory)


The dash represents a checkbox and I'd like to be able to tick e.x. both pens in writing instruments and recycled pens in recycled products for a product called "recycled pen".

What I will have is the following tables:
1. products with subcategoryID as the foreign key
2. subcategories with categoryID as the foreign key
3. categories with no foreign keys
4. a linking table with productID and subcategoryID

Please can you let me know how to do it in dreamweaver?

Reply to this topic