need help with a little dode with batch report

[milano]

i am using batch center contribution and every thing works fine .i have made a little change that allows me to search for a match on one of the extra fields that i have made with purchase order contribution.

i want to be able to do two diffrent things

1- choose which diffrent db fields to search from the admin area like i might want to search in date or by customer or by purchase order no

2- search for any match in any of the three fields vac_one vac_two and vac_three at the same time.these are the serial numbers and i would like to find orders associated for that serial number. orders can have maximum of three serial numbers.vac_one two and three

the code here now only searches vac_one

$orders_query = tep_db_query("select o.orders_id,h.comments,MIN(h.date_added) from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_STATUS_HISTORY . " h where o.vac_one ='" . tep_db_input($date) . "' and h.orders_id = o.orders_id" . $pull_w_status . $get_customer_comments . ' group by o.orders_id');

any help?