Hi all..
I have the option type feature installed and its an awesome contribution..
For me it works seemless and also works well with the attribute ajax manager..
Anyway, i have a bit of a technical question which im hoping someone can help me with..
Ok, when we use a select box the options it displays are in id sort order..
Now my question is that is it possible to sort this alpabetically.
Now ive scanned the code on the product_info page and believe this is the query..
$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.options_values_id");
As you will see this is soerted by options_values_id, now ive tried changing that id to name but no joy, and to be honest the query is well over my head..
So if anyone can shed any light i would be most gratefull..
Thanks all