select query with multiple items

[nikko50]

I have a select query and would like to know if there is a better way. The select query just selects itemid where itemid=111 or itemid=112 or itemid=113 and so on. Can I possibly create an array of items and use this array in the select query?

[laserlight]

You could try a:
$itemids = implode(',', $array);
Then in the SQL query:
WHERE itemid IN ($itemids)

[nikko50]

I have mysql 3.23. Will this work??

[laserlight]

After you try, you'll find out.

[nikko50]

Works great. Thanks laserlight