How to setup this table

[NoBullMan]

Hi,
I need some insight on how to setup a table.
I have a table of items for ordering, some of which depend on existence of other items in the cart. I set up a field in the table called "Requires" where I list the item_ids of the items that are pre-requisites for this item. My difficulty is some items might require one other item, or any one of many items or all of the items listed in this field.
I am not sure how to set up the table, how to distinguish among them (if this item requires all of the items listed in "Requires" or any one of the items listed) and how to handle it in php.

I really appreciate your help.

[bastien]

Have a table called products with a boolean (Y/N, 1/0)field "REQUIREMENTS"...

Have another table called requirements
has two fields

product_id
req_prod_id

When the item is to be added to the cart, you check the product table for the requirements field, if yes, then get the list of requirement "parts" from the requirements table and the products table....

Check the list of requirements against the list of items the user has choosen...If some are missing, then notify the user that additional "parts" are required and ask if he wants to add them...

[NoBullMan]

Thanks Bastien.
I have this part set up and it works fine. My problem is that some products need one of many items to be in the cart already and osme require all of the items. My "Requirements" field contain a list of items, separated by comma. In my php file I get the content of this field and "explode" it and check for existence of each item in the cart. If I find ANY of them I return true, else false.
The problem is now there are products that need more than one item to be in the cart. This is what I don't know how to set up.

Table "Items":

ItemID : 1234
ItemName: Widget
...

Requires: 11, 22, 33 (item 1234 requires ANY one of these item)

ItemID: 5678
ItemName: Another Widget
....

Requires: 44,55,66 (item 5678 requires ALL of these items)

How can I set up the table to be able to distinguish between the two (ANY and ALL)

[bastien]

add another boolean field to items...require_all and set it to 0 for ANY and 1 to ALL...then use that value to check

[coolT]

Create 3 tables

table 1 order
orderID

table 2 requirements
requirementID
requirementDescription

table 3 order_requirement_join
rowID
orderID
requirementID

table 3 can then contain
order 1
requirement 1

order 1
requirement 5

order 2
requirement 1

order 2
requirement 2

order 2
requirement 5