Help! I need to write multi-selection form data into field?

Hi,

I have a database and one of the fields is populated by a multi-selection form field, in this case, checkboxes. I've named all the checkboxes the same name as the field and allocated different values to each but only the first checkbox value shows up in the database. Is there some trick here? Do I need a separate field for each? I would just like to have them listed in the database.

Thanks to anybody who can help me!

Add a pair of squarebrackets to the end of your field name in the HTML form - when that field is returned to your script, you'll be able to access the field values as an array. Yes, it's a dodgy hack, but it's the only way PHP can do it.

More info: http://academ.hvcc.edu/~kantopet/ph...php+client+side
"Form field names" section

Thanks Stumpy. I will try that!

Hi Stumpy - Okay - so I've added the square brackets and been to your site and it all seems to make sense, until I run the script and I keep getting parse error. I did this with Dreamweaver MX so maybe the script is slightly different:

This is the original code to extract checkbox data from a form with checkboxes named 'interests[]' with values: Business, Entertainment and Finance



Does the array go in like this?



or this?



whatever combination I use brings up a parse error.

On you site you wrote

Where would this code go? After or within the first line? I just don't know how to apply your code to mine because I don't have enough experience with PHP code I'd appreciate any assistance!

Thanks in advance!