How do I control the display order in Coupon Admin

[nut4squirrel]

I've tried to sort the coupons table in phpMyAdmin to make finding a coupon code in ZenCart Coupon Admin easier. This sort kind of works but is not completely successful. There seems to be other forces at work the cause the displayed list to show not in pure Coupon Code order.

I looks like dollar discounts are shown first, then percent discounts.

What can I change to always show the list in Coupon Code order?

-Thanks, Alan

[Ajeh]

Look around line 994 and you will see the code where the SELECTs are made ...

In this example, the sort order has been set to sort by the Start date of the coupons:

    if ($status != '*') {
      $cc_query_raw = "select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from " . TABLE_COUPONS ." where coupon_active='" . zen_db_input($status) . "' and coupon_type != 'G'" . " order by coupon_start_date";
    } else {
      $cc_query_raw = "select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from " . TABLE_COUPONS . " where coupon_type != 'G'" . " order by coupon_start_date";
    }

you can try the field:
coupon_code

instead of the field:
coupon_start_date