Selecting Mutiple item from drop down list and saving them to a Mysql table

rohanm02

I am using
<select name="aot_dept1" multiple>
<option value selected></option>
<option value=Sales_and_Marketing>Sales and Marketing </option>
<option value=Product_Department>Product Department </option>
<option value=Inbound_FIT-Australia>Inbound FIT - Australia </option>
<option value=Inbound FIT - New Zealand >Inbound FIT - New Zealand </option>
<option value=Groups - Australia>Groups - Australia</option>
<option value=Groups - New Zealand>Groups - New Zealand </option>
<option value=Incentives - Australia>Incentives - Australia</option>
<option value=Incentives - New Zealand>Incentives - New Zealand </option>
<option value=Shipping - Australia>Shipping - Australia </option>
<option value=Shipping - New Zealand>Shipping - New Zealand </option>
<option value=Fly Drive - Australia>Fly Drive - Australia </option>
<option value=Fly Drive - New Zealand >Fly Drive - New Zealand </option>
<option value=Conferences - Australia>Conferences - Australia </option>
<option value=Conferences - New Zealand>Conferences - New Zealand </option>
<option value=Familiarisation Tours>Familiarisation Tours </option>
<option value=Administration>Administration </option>
<option value=Database>Database </option>
<option value=Accounts>Accounts </option>
<option value=Information_Technology>Information Technology </option>
</select></font>

in a php page.

The user can select multiple items however only the last item is being saved in the mysql table. How can I add and retrieve multiple items using a drop down list.

planetsim

The reason for that is. Its because its the selected value.

Im not sure how you select all of them then. But if someone can work that out.

Its all a matter of looping the UPDATE query.

cgraz

To get more than one value, you have to make php return an array when the form field is processed. To do that, change your form field name to

The brackets create an array which can be accessed on the next page by using $_POST['aot_dept']. You can loop through to get all the values the visitor selected.

Cgraz

Jeremiah

I am having a very similar problem, but with checkboxes. BTW, I thought I had the same problem with multiple selection lists, and I did, until i figured out that i only wanted the user to select one, so when I fixed that, there was no overwriting, b/c there was nothing to overwrite. But when I still thought I needed multiple values from the drop down menu in my db, fixing the html on my form was not the problem.

So anyone know how to get multiple values from a checkbox array into a db?

cgraz

yeah, name your checkboxes as arrays using brackets [] so they all have the SAME name. The results will be put into an array. Then, loop through the array using a foreach loop and INSERT into your database.

Cgraz