MySQL Action to multiple selections

[Anon]

I have a form with a field where people can select more than one item. When the form is submitted, I am trying to set a value for each of the selected items into a MySQL database. I can't figure this out. Can anyone help?

Here is the basic code for the form I am using:

<form method=post action=test.php>
<select name=selection size=5 multiple>
<option value=person1>person1</option>
<option value=person2>person2</option>
<option value=person3>person3</option>
</select>
<input type=submit>
</form>

Basically I want to set a value to [1] or [0] depending on some other variables in a row that already exists.

[badman]

hello jason,

Change this
<select name=selection size=5 multiple>

TO
<select name=selection[] size=5 multiple>

in the action page (test.php) you will have an array called $selection which has all the selected option values .
Cheers!