Form with Multi Value Checkboxes

Hi,

What's happening is because all of your checkboxes have the same name, they are overriding the previous boxes values in the $_REQUEST array. You can get around this by adding square brackets ([]) to the end of the check box field name like this:

<input type="checkbox" select multiple="multiple" name="adults[]" ...

This will make form return an array for $_REQUEST['adults'], with each element of the array being a value that was checked.

This means that you will then have to take that array and turn it into a tab (\t) separated string like this:

$adults = "";
foreach ($_REQUEST['adults'] as $adultValue) {
$adults .= "\t".mysql_escape($adultValue)."\t";
}

You will then be able to put it into your SQL query like this:

adults = '$adults',

Hope this helps get you started.

Ok, I thought I had it but I keep getting an error that says line 40.

Hi,

The code I gave you needs to take place after the form has been submitted, but just before you write your INSERT statement.

Try the file attached.

Hope this helps