Setting a multiple drop down to a variable

[webqueen79]

I have a multiple select box that I am trying to populate into a database. I cannot figure out how to set the selections to a variable and then store them in the database. I tried to just set the Request object into the database and it only stores one selection. Please help!!!

Here is my code so far:

<form action="signup.php" method="post" name="frmThis" onsubmit="return submitForm();">

<select name="Owned_Before[]" style="font-family:verdana; font-size:10px" multiple>
<option value="ATV">ATV</option>
<option value="Boat">Boat</option>
<option value="RV">RV</option>
<option value="Snowmobile">Snowmobile</option>
<option value="Waverunner">Waverunner</option>
</select>

[maxpup979]

The multiple select carries the selections across in an array, so that may be what is giving you issues.

if you are putting them all in one field, try using $field=implode("|",$_POST["Owned_Before"])

if you need to put them in seperate entries, just loop across the array.

Hope that helps