Kit assembly with PHP/MYSQL. An interesting problem.

[poleposters]

Hi,

 

I have items A, B & C that belong to a bundle/kit.

 

These items don't always arrive together in the same shipment.

 

I want to be able to determine the soonest availability of each kit.

 

I have an inventory table that looks like this. (One item per row. Shipment is usually a date. I've used integers to simplify the example)

 

ITEMSHIPMENT

 

A1

 

C1

 

C1

 

B2

 

B2

 

A3

 

A3

 

B3

 

C3

 

 

As you can see, the first complete kit becomes available in Shipment 2, The second complete kit in shipment 3, and the third complete kit also in shipment 3.

 

Its pretty easy to work out in my head. But how do I do it with PHP/MYSQL?