adding product options

Does this work with static pages meaning I have to recreate the cart behaviors to all 9 product pages....correct

when adding produt options ie rsColor the part I pasted into the sql has optiongroupID ='color' I fill out the rest and the new one shown shows optiongroupID =1 mine does not show that..
it shows
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

what did I do wrong.....

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'

and for the primere ticket. what would I do so I am prepared to do this in the least amount of time I am hoping if you can help me set up one out of the nine pages and then I could do the other 8 myself

What would you need for me to set up to be able to be guided through it all, would I need to star over?
one item looks like this....
1. Choose a size and add $2.00 to to the cart for each size bigger then XL ie 2XL +$2.00 3XL +4
2. Choose a color
3. Choose a charter (55 of them)
and then send it to the cart and checkout and ship using sandbox to test?
Then I should be able to just duplicate the other 8 pages? I cannot afford the $99 but I need to see how this is done!
If so what is the earliest time slot we could attempt this?

it errored it out sql error ????

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE optiongroups.OptionGroupName = 'color' AND productoptions.ProductID = -1' at line 1

the SQL i posted in my reply does not have anything to do with optiongroups.OptionGroupName = 'color' in it.

i tested the sql from my reply:
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'

and did not get any errors.

you will not need to start over. using what you have now, we will look at what you have done sop far, to see where the problems are, and how to correct them.

if you contact the sales department, they will be able to give you a time frame for when the next available appointment is.

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?

statement you sent me goes....

Trying to get this at least workable by noon....