Index: oscommerce2/trunk/catalog/account_history.php =================================================================== diff -u -r477 -r1739 --- oscommerce2/trunk/catalog/account_history.php (.../account_history.php) (revision 477) +++ oscommerce2/trunk/catalog/account_history.php (.../account_history.php) (revision 1739) @@ -1,11 +1,11 @@ 0) { - $history_query_raw = "select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by orders_id DESC"; + $history_query_raw = "select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.public_flag = '1' order by orders_id DESC"; $history_split = new splitPageResults($history_query_raw, MAX_DISPLAY_ORDER_HISTORY); $history_query = tep_db_query($history_split->sql_query);