List Multiple Selection to MySQL

Question

How do I take multiple selections from the List box in a form
in Dreamweaver 8 and post to MySQL?

I tried using implode as recommended here: 
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=12&catid=263&threadid=1112556&highlight_key=y&keyword1=multiple

This worked unless the user did not select any items in the
list. Then I received a bad arguement error message.

I then tried just using POST without the implode and [] on
the end of the select name, but this put the word "Array" in the
column/row in the database instead of the data.

I then tried the POST with the [] on the select name and []
in the SQL statement: GetSQLValueString($_POST['appliances[]'],
"text"), Dreamweaver would not let me associate this under Insert
Record in the Server Behaviors section - so Null is put in the
database.

I need to be able to post multiple items selected from a list
box to MySQL, but allow the user not to select anything from the
list box without receiving an error.

Anonymous · Accepted Answer

Thank you so much for your assistance. Ultimately, it worked with putting the [] after the name and with the following code:

GetSQLValueString(isset($_POST['appliances']) ? implode(" - ", $_POST['appliances']) : "", "text")

Newsgroup_User · Answer

dulcey1 wrote:> How do I take multiple selections from the List box in aform in Dreamweaver 8 > and post to MySQL?Multiple select lists produce an array if anything is chosen,but do not appear in the $_POST array if nothing is chosen. Since thename of your multiple select list is appliances, you must put squarebrackets after the name in the form (name="appliances[]").To prevent errors, check whether $_POST['appliances'] exists.If it does, extract the values with implode(). If it doesn't,create an value to indicate that nothing was selected.$appliances = (isset($_POST['appliances'])) ? implode(',', $_POST['appliances']) : 'None';-- David Powers, Adobe Community ExpertAuthor, "Foundation PHP for Dreamweaver 8" (friends of ED)Author, "PHP Solutions" (friends of ED)http://foundationphp.com/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded