You wrote
since your product pages are static, you need to add a where clause to tell it what product to return the options for:
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 productoptions.ProductOptionID = '1'
Today 04:04 PM
Where does this stament go? I was building the product options for rsColor you told me I needed the above sql statement where does it go?