# SQL Select ... order by

**URL:** <https://forum.kirupa.com/t/sql-select-order-by/314946>\
**Category:** programming\
**Created:** [October 13, 2010, 1:23am UTC](https://forum.kirupa.com/t/sql-select-order-by/314946 "2010-10-13T01:23:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charlieku](https://avatars.discourse-cdn.com/v4/letter/c/7c8e57/32.png) [@Charlieku](https://forum.kirupa.com/u/Charlieku)\
**Post date:** [October 13, 2010, 1:23am UTC](https://forum.kirupa.com/t/sql-select-order-by/314946/1 "2010-10-13T01:23:32Z")

</div>

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.