Multiple selects and database queries

[hanshans]

How do I insert the values of a variable which is posted by a form with select multiple controls into a database?

Example:

If I have "<select name="select1" size="6" multiple>
<option selected>Bitte w&auml;hlen Sie!</option>
<option>Alarmanlagen</option>
<option>Brandmeldeanlagen</option>
<option>Notdienst</option>
<option>Schl&uuml;sseldienst</option>
<option>Zutrittskontrollsysteme</option>
<option>Personenschutz</option>
</select>" the variable "select1" has 6 values: select1=Alarmanlagen&select1=Brandmeldeanlagen etc.

Thank you!

[Anon]

Change the select variable to be an array like so:

<select name="select1[]" size="6" multiple>

Then you can do this:

while (count($select1[])>0){
$value = array_pop($select1);
$query = "insert into table values('$value');
CODE TO INSERT TO DB HERE;
}

That should do it

[toma42]

The code is easier to read and understand if you use

foreach ($select1 as $value) {
$query = "insert into table values('$value')";
}

count + array_pop is really the hard way to do it.