Splitting a row...

[dannyluked]

Hi,

I have 2 tables,

Table 1

ID | Name

1  |  Item 1

2  |  Item 2

 

Table 2

ID | Name        | nomb

1  | Product 1  |    1 3 5

 

I want to make something that will echo the rows in Table 2. However, if the user selects a product from 'Table 1' (like Item 1) they cant have certain item(s) from 'Table 2'.

 

Example,

If user chooses Item 1 (with id '1') they cant have a product from Table 2 because it is not compatible. Whether it is compatible is stated in the 'nomb' column. In there the ID's of none compatible items from Table 1 will be stored. At the moment the 'nomb' column states that it is not compatible with items from Table 1 that have the ID 1, 3 or 5.

 

Basically I need to split up the column 'nomb' (remove the space) and give it its own variable.

 

Further exaple,

1) User Chooses Item 2 from Table 1 so they can have the Product in Table 2

2) If user chooses Item 1 then they cant have another product because it is not compatible with Product 1 (the 'nomb' column contains the ID of Item 1)

 

Thanks in advance and I'm sorry it is so hard to understand