Thank you for your help.
I spent the last two hours trying to make sense of your post. When it comes to databases I feel like a toddler.
So here is what I understand:
ItemID | Name __ |SizeID
1 ____ | Product a | ?
SizeID | Description
1 ____ | M
2 ____ | L
ItemID | SizeID | Price
1 ____ | 1 ____ | 10.00
1 ____ | 2 ____ | 12.00 (or does the ItemID in this table have to be unique?)
I don't know what to put into the SizeID field marked with the question mark. This is where the customer should make the choice. If I predetermine a value like "1", wouldn't that be just the same as putting the actual size "M" in there?
And to make it a little more difficult our products come in different sizes and versions. Here is an example:
- Product A, Size 1, version a, price=10.00
- Product A, Size 2, version b, price=22.00
- Product A, Size 1, version b, price=12.00
- Product A, Size 2, version a, price=20.00
So, for the table tblprice I could not enter a price, because it would still depend on the version the customer picks.
And here you lost me completely
"On your item detail page, you can query your price look up table which is filtered using sizeid and itemid variables posted from the add to cart form. Then you can pass the price returned from the query into the cart array."
Unless I can click on the lightening bolt I am lost. I have not the faintest knowledge of PHP.
Do I need to hire a specialist? I mean, is there any chance for a beginner to pull this off?