inserting multiple selects from list

[dadoonan]

I have a dynamic form that includes a dynamic, multi-select list. I'm able to make multiple selections from the form, but upon submission, only the first item selected is being saved in the db.

Any ideas what I'm missing???

thanks,
david

---

The insert code is:
$ins_Residential->addColumn("Res_Appliances", "STRING_TYPE", "POST", "Res_Appliances");

---

The form field code is:
<select name="Res_Appliances" size="1" multiple="multiple" id="Res_Appliances">
<?php
do {

?>
<option value="<?php echo $row_GetAppliances['App_Name']?>"<?php if (!(strcmp($row_GetAppliances['App_Name'], $row_rsResidential['Res_Appliances']))) {echo "SELECTED";} ?>><?php echo $row_GetAppliances['App_Name']?></option>
<?php
} while ($row_GetAppliances = mysql_fetch_assoc($GetAppliances));
$rows = mysql_num_rows($GetAppliances);
if($rows > 0) {
mysql_data_seek($GetAppliances, 0);
$row_GetAppliances = mysql_fetch_assoc($GetAppliances);
}
?>
</select>
<?php echo $tNGs->displayFieldError("Residential", "Res_Appliances"); ?>

[devinemke]

a simple example:

<form action="" method="post">
select 1 or more numbers:<br>
<select name="numbers[]" multiple>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select><br>
<input type="submit" name="submit" value="submit">
</form>

<?php
if (isset($_POST['submit']))
{
	if (isset($_POST['numbers']))
	{
		echo 'you selected: ' . implode(', ', $_POST['numbers']);
	}
	else
	{
		echo 'you did not select any numbers';
	}
}
?>