My osCommerce template’s Select command includes “order by m.manufacturers_name desc”, which correctly displays them as a list in descending alpha order. I want the list in ascending order. When I use “order by m.manufacturers_name” or “order by m.manufacturers_name asc”, I get a repetitious list of only the first manufacturer, but with none of the other names. How can I produce a list of names in ascending order? Thanks for any help.