Multi-Query...can it be done?

[knelson]

Hello...I don't think this is possible within a single query, but if anyone has a clue, I'd be very grateful:

1. Original form has 10 fields for unique item numbers x1, x2, x3...
2. Query would (ideally, according to mgmt.) process all these list items with a single click.

select * from table
where item_number = x1, x2, x3

-you get the idea. Can perform a single query with a list of items that match a single field name? Do I have to transform the original list into an array first, and then run multiple queries somehow? Or do something else?

version: mysql-max 4.03

thanks for your time. this originally struck me a fundamentally impossible, but I figured that I might be missing something basic.

knelson

[Lars_Berg]

if you have the list in $items

$q = "select * from t
where item_number in (" . $items .")";