\|/ html multiple select array and mysql
| From: | Gerry Figueroa Anadon | Date: | Tue, 06 Nov 2001 18:26:11 +0000 |
| Subject: | \|/ html multiple select array and mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-73615@lists.php.net to get a copy of this message | ||
Hello:
I need to find out why my multiple[] array is loading the word "Array" into MySQl table
instead of
the array values.
I've search all the lists and all I've learned is to put the [] to make my select an
array.
this is the html:
<select name="planes[]" multiple>
<option value="La_Reforma">La Reforma
<option value="Cruz_Azul">Cruz Azalea
<option value="Triple_SSS">Triple SSS
</select>
and here is my sql:
$result = mysql_query("insert into doctors values(\"\", \"$nombre\",
\"$apellido1\", \"$apellido2\",
\"$especialidad\", \"$planes\", \"$direccion_postal\",
\"$direccion2\", \"$pueblo\", \"$zip_code\",
\"$telefono\", \"$fax\", \"$website\", \"$email\",
\"$idiomas\", \"$intereses\", \"$comentarios\")")
or die ("could not execute");
Before I learned to make the name an array I would just get the last or first value.
I would gratelly appreciate a push in the right direction!!!
Many Thanks:
--
Gerry Figueroa
Dynamic Intermedia