Dynamic Radio Buttons

[lewisb]

Help much appreciated on this by PHP newbie!

I have a database table that contains categories (up to 14) but these can be amended. I have a product table that draws data from the categories table to determine which category a product fits in. This will often be more than one of the available categories. I want to have a series of radio buttons that can be selected; the labels and values of which are drawn from the category table. When the product table is updated, though, I want the (values of) selected radio buttons to be inserted into only 1 field, so that this single field can be searched for any of the values denoted by the selected radio buttons... Any clever bod know the answer to this one?

Thanks in advance,

Lewis.

[Anon]

radio buttons are intended to be used to specify ONE option of many. YOu want to use check boxes.

1. Loop through your result set of categories.
2. print a checkbox for each category, name each category as part of an array i.e. "category[cat_name]")
3. on the processing page, implode the resulting array with a join of ', ' - you will end up with a string of all the selected categories.
4. insert into DB

[lewisb]

Thanks Craig - I had an idea that this was the way to do it and spent a fair while trying... If you have time to put it in idiot's terms (ie the code!) I would be seriously grateful!

Cheers,

Lewis.

[Anon]

sorry, but I do not. :-(