multiple drop downs and MySQL

[mduran]

Hello,

Here is my problem:

I have a form with a multiple drop down menu allowing to select more than one item at a time, but it will only pass to the MySQL db the first selection. How can I pass the values of more than one selection and make it end up in the database with a comma or space separator (or similar) ?

Thank you.

[xblue]

As far as I remember you simply have to append [] the the name of the select tag, e.g.
<select name="selected_items[]" multiple>

The you would get all selected values into an array.
To create a string from that array, you can use implode() or join().

Hope this helps,
xblue

[sarah]

xblue is right on...make the name of the dropdown blahblah[] and then use the following to turn the array into a comma delimited string...

$dataWithCommas=implode(",", $blahblah);

[mduran]

Originally posted by sarah
xblue is right on...make the name of the dropdown blahblah[] and then use the following to turn the array into a comma delimited string...

$dataWithCommas=implode(",", $blahblah);

I am using the name of the menu in a Javascript function and the brackets seem to be a problem (things like document.SubmissionForm.blahblah[].options[index].text = ' '; will not work. I'd better address this question to a Javascript forum, but in case some of you guys has some knowledge...

Any idea ?

Thank you!

[mduran]

I'm answering to my las own post. I got the solution from another forum. The trick consists in using

document.SubmissionForm.elements["blahblah[]"].options[index].text = '';

instead of

document.SubmissionForm.blahblah[].options[index].text = '';

thanks anyway.