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

Thank you so much! That works. Learn something new every day.