Ok... I don't know Php outside what Dreamweaver will automatically generate for me.
Sooo... I"m going to need a little more hand holding.
Below is the code I already have within the recordset (based on the "Product Options w/eCart" tutorial)
Here are the names of the 3 columns I crated within the options table.
CategoryID (this the column I'm using to filter which colors should be displayed for that product. The column should contain the number 1 for large handbag, or 2 for small handbag.)
LargeBagList: (This is the order for how to the corresponding colors should be listed) I need this column to be sorted in an ascending order.
SmallBagList: (This column is the same as the LargeBagList. But contains the list order for the Colors available the small handbag.) I also need this sorted in an ascending order.
So what I'm guess you are telling me to do is to add the filter and sort options by hand coding it. This is where I'm going to need the help. What do I need to add to the code below to in order to filter by the CategoryID column with a value that contains the product number (1 or 2 based on the product page)
Then I will need the LargeBagList column sorted in an ascending order.
(Again this is the code I already have... what do I need to add to it?)
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.ProductOptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'color' AND productoptions.ProductID = paramItem