remove orders when status changes

[gloerick]

I appriciate the reply, but I really do not understand what to replace,
I did find the code you state in the file but not sure on what to change.

<?php $customers = $db->Execute("select c.customers_id as customers_id, c.customers_firstname as customers_firstname, c.customers_lastname as customers_lastname, a.customers_info_date_account_created as customers_info_date_account_created, a.customers_info_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_INFO . " a on c.customers_id = a.customers_info_id order by a.customers_info_date_account_created DESC limit 5");

[Ajeh]

You can add a where statement to this by changing line 155 to:

  <?php  $orders = $db->Execute("select o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id, o.date_purchased as date_purchased, o.currency, o.currency_value, ot.class, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id and class = 'ot_total') WHERE o.orders_status < 3 order by orders_id DESC limit 5");

NOTE: line number and code change I goobered up in the last post ...

[gloerick]

That seems to be it, thank you so much,
all the older delivered orders are off the ADMIN HOME page and now only the
NEW pending orders that need attention are showing.

Thx SO MUCH, it took off ALOT of cluder.

Erick