Show Certain orders only on admin index page

[DigitalShadow]

Can anyone help me, i've tried searching, found something that should have done it, tried it, and it didn't work.

I'm trying to get the "new orders" section on the admin page to only show a certain order status.

In my case status 2

i've tried using the code

orders_status != 2

and it made things change, but the results were odd and not what i expected.

Can anyone please help?

[Ajeh]

Around line 165 in the file:
/admin/index.php

you will see the line:

  <?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) where class = 'ot_total' order by orders_id DESC limit 5");

change it to read:

  <?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) where class = 'ot_total' and o.orders_status = '2' order by orders_id DESC limit 5");

[DigitalShadow]

Thank you very much, working perfectly :)

[Ajeh]

You are most welcome ... thanks for the update that this worked for you ...