Using one array to generate another array from a database?

[HairyArse]

Hi guys.

I have 3 tables - demands, demand_orders and bill_of_materials.

Demands is related to demand_orders and bill_of_materials is related to demand_orders but I need to query bill_of_materials based on data in demands.

So how can I do this?

Basically my query for demands is:

SELECT item_id FROM 4182_demands WHERE demand_order_id = '$demand'.

I then need to use the results of that query in an array to query:

SELECT * from bill_of_materials WHERE bom_item_id = the above array....

But I'm not sure how to code this? Does that make sense, can anyone help?

[HairyArse]

Never mind - it's me being a numpty!