form: three values to one database field

[siobhan]

<td width="67"><label>
<input name="oc6" type="checkbox" id="oc6" value="oc6">
oc6</label></td>
<td width="63"><input name="oc2" type="checkbox" id="oc2" value="oc2">
oc2</td>
<td width="54"><input name="oc1" type="checkbox" id="oc1" value="oc1">
oc1</td>

I have three checkboxes, the values of which I would like to have inputted into a one table field. Users can select one, two, or all three of the checkbox options.

How do I write the code for this? Where do I incorporate it into above?

[Roger_Ramjet]

Siobhan, why 3 values in 1 field? And what data type is the field? Finally, how to you intend to use the values later?

Given that you must then it's if (isset($_POST['oc6'])) { etc to get the checkboxes that were clicked.

Now the datatype of the db field will determine how you need to build the query string. If it is char then you just concatenate the value to the query string.

You could however use a bitmask approach. Your db field would be a tinyint and you would use the Bitwise operators to manipulate and query the stored values. Read the user notes on the manual page for functions that do what you need.