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:
you can try the field:Code: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"; }
coupon_code
instead of the field:
coupon_start_date


Reply With Quote
