I have changed the order code to
ORDER BY options.OptionID", GetSQLValueString($OGIDParam_OptionValues, "int"));
unfortunately this action creates a lot of problem to me.
on the page Products.Detail.php the option presented like what I need
eg., size (the order I insert in Admin)
when I try to choose Size S + Colour Red, on the name of product came up Size M + Colour Black
I even deleted this product and insert completely again, but still came out the same problem
I notice that when I edit product with a combination of options in Admin, the URL shows for example ProductID=1100
but when I choose the product with the same options combination in Products.Detail.php. the URL doesn’t change but remain the old ProductID=1090.
Then I enter the new ProductID=1100, the product shows up correctly.
Can anyone tell me what is the problem here? THANK YOU
Here is the website product page