Pricing Dropdown Menu Kicking my arse!!

[rockgremlin]

Hello!!

 

Trying to get my site up and running, but having several issues with setting up a pricing dropdown menu option. When I go in and list my products in the order I want them to appear, for some reason, they come out all jumbled! :angry:

 

My site: http://classicimagery.net/catalog/

 

Click on one of the images on the top row (Retired Machinery, or Aged Oil Dump2), and take a look at the pricing dropdown menu. IT'S A JUMBLED MESS!!!

 

I want it to dropdown in a neat, clean fashion like this:

 

Matted 8X10

Matted 11X14

Matted 16X20

Matted 20X30

Unmatted 8X10

Unmatted 11X14

Unmatted 16X20

Unmatted 20X30

 

How do I make it do that?

 

Any other advice is welcomed also.

 

Thank You!!!

[cindie]

copied from reply to my topic

-cindie

 

--------------------

 

Folks,

 

Look for Option Sort in the Contributions.

 

ed

 

 

--------------------

[cindie]

On second thought, maybe just do this like I did. Find this code somewhere around line 142 on product_info.php in your main oscommerce directory and make the additions marked in red. Then everything will sort by Attribute ID. (which I think it should do in the first place but that's just me.) Or install some crazy thing, your choice! :D

 

----------------------------------------

 

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id 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.products_attributes_id");