+--------------+-------------------+
| 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):
Code: Select all
$temp_arr = array() //boxes that were checked
"SELECT Product_image FROM My_products WHERE Product_id IN ($temp_arr)"Thanks
L