inserting checkbox values into SELECT st

[Anon]

Hi,
I am creating a search engine that returns values in a compact format. Each one should have a checkbox, allowing the user to check the ones s/he is interested in, and then use SUBMIT and get a page in return that has all details for each checked product.
The products are identified like this
checkbox name=productid value=unique_value

values are different but checkbox "name" is the same for all of them.
Im trying to capture the output of all unique_values to a variable that holds a comma seperated list of all selected items.
example
$selected_products =(prod1,prod4,prod8,prod6)

I want to use the $selected_products in the
SQL SELECT like this ... WHERE productid IN ($selected_products)

Any help'd be greatly appreciated.

[Anon]

try using a '[]' after the name like this:

checkbox name=productid[] value=unique_value

when posted,
you will get an array of productid's

you could put the productid's together in one string with join()

hope this helps

[Anon]

thanks a lot, that did it!
I ended up using implode, but it's the same thing more or less

[parkley]

now do numbers need to go between [] in order for it to return different results...

i am trying to do a lil' order form where i am using check boxes... I want all the checked items to be displayed on a confirm screen... but i can't seem to get it to work....