Attribute manager - sorting attributes on SELECT

[chrismole]

Is there a way to re-sort the attributes on the Attribute Manager page? It seems that if I use the Attributes Manager to create product attributes, the INSERT statement creates the attributes in the order they're listed on the Attribute manager page (which looks like ascending by option_id).

For example, I have an attribute named length with values 32", 34", 36", etc. In attribute manager, they are listed descending, 36, 34, 32. When I check off these attributes for a product and apply changes, they seem to be inserted into the db with 36 first, then 34, then 32. So if I sort my attributes by option_id, I get 36" listed first in the product dropdown rather than 32".

Bascially, I am asking if there is a way to re-order the options listed in Attribute Manager so thay are ordered by option_id (the order they were created in Product Attributes)? I've tried adding "order by option_id" to all the SELECT queries in new_attributes_change.php, but no luck.

thx,
C

[chrismole]

I figured it out. The SELECT statement is in:
admin/new_attributes_include line 58. Here's the statement:

$query2 = "SELECT * FROM products_options_values_to_products_options WHERE products_options_id = '$current_product_option_id' ORDER BY products_options_values_id DESC";

simply change the "DESC" at the end of the statement to "ASC", like this:

$query2 = "SELECT * FROM products_options_values_to_products_options WHERE products_options_id = '$current_product_option_id' ORDER BY products_options_values_id ASC";

A plus is it saves the attributes in the same ascending order, based on the order in which you entered them into admin Products Attributes manager. This is handy if you have numerical values in an attribrute dropdown that you want the customer to see in ascending order.