Optionlist - sortfunction

[celeb-x]

Hi!

 

I was wondering if anyone found an solution yet for sorting the optionlist: ( example product )

 

Awaiting your response,

Snt

[♥olby]

Look for this line in catalog/products_info.php:

 

$products_options = 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 = '" . $HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "' order by pov.products_options_values_name"); // added sort on options 08.07.02 olby

 

It's the order by (in bold) that does the trick.

[celeb-x]

Kewl, it works!

 

Thank you verry much! :)

 

Greetz,

Snt

[Guest]

Does this work with the new version of OSC and if so, where is teh "products_info.php" file

Dean

 

 

Look for this line in catalog/products_info.php:

 

$products_options = 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 = '" . $HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "' order by pov.products_options_values_name"); // added sort on options 08.07.02 olby

 

It's the order by (in bold) that does the trick.