Product Options, size list
I followed the instructions on the "Product Options with eCart" tutorial and got everything *almost* working. Problem is, my size dropdown menu is showing all the sizes for every productID instead of pulling from the productID that matches the item being pulled from the recordset.
This is what I have for rsSize:
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'Size' AND productoptions.ProductID = paramItem
paramItem runtime variable:
$row_rsProducts['ProductID']
And for rsSizeLookup:
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'Size' AND productoptions.ProductOptionID = paramOption AND productoptions.ProductID = paramItem
paramOption runtime variable:
$_POST['eCart1_1_size_Add']
paramItem runtime variable:
$_POST['eCart1_1_ID_Add']
My tables are set up/named just like the tutorial so I'm confused why this isn't working.
Any suggestions?