Product Attributes in Alphabetical Order

[starynightskyz]

I have tried over and over and have added and deleted and added and deleted to the attribute section to try to get the colour listing for a product drop down menu to come up the same way I put them in

 

How I would like to have it apear in the cart is:

 

" Select A Colour " as the top defult.

Amathyst

Aquamarine

Black Diamond.

 

And so on down the line till it gets to the Z's Ive put them in forwards, and backwards. But still it

comes in all mixed up.

 

Does anyone have any sugestions ?

[Guest]

the order of display can be changed in the catalog\product_info.php file

 

So there should have some code for the attribute values:

 

like this:

		$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 . "'");

 

you can change it to this and try:

		$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 pov.products_options_values_name");

[starynightskyz]

Hey that worked great!!!!!! Thank you very much!!!

 

Nancy :D