PHP, MySQL & checkboxes

[lentildal]

Hi all

+--------------+-------------------+
| Product_id | Product_image |
+--------------+-------------------+

I have a table with two columns as in the above diagram.

I have a page with 5 checkboxes like this:

<input type='checkbox' name='Prod_chk' value="<?= $array['Product_id']">

I want to run a query on my table to select the relevant products when a user checks some of the boxes but I'm stuck.

Is there some way of selecting the checked boxes something like (I know this syntax doesn't actually work):

$temp_arr = array() //boxes that were checked

"SELECT Product_image FROM My_products WHERE Product_id IN ($temp_arr)" 

Thanks
L

[Ramiro S]

I dont get it... do you want some example to display the checkboxes selected depending on the database info

or

select from the database what the customer selected in the checkboxes?

[lentildal]

Hey

thanks for replying - its cool, I worked it out.

I was trying to find a way of getting an array into the 'IN' part of the query. It wasn't working because I had some quotes missing.

Cheers
L