Form to post several questions into one feild

Hi, Jason,

I have a form with about 20 questions and the last has several choice selected by radio but, but some questions might no be answered. Is there a way to capture the static info and then place all of the multiple questions into one field in the database?

thx
Eric

Instead of using Radio buttons, use checkboxes.

name them all the same so that they will be a checkbox group.

the checkbox group will send the selections as an array. You can convert the array to a comma separated list using the following code on your page:

<?php

if($_SERVER["REQUEST_METHOD"] == "POST")     {

    foreach($_POST as $key => $val) {

        if(is_array($_POST[$key])) $_POST[$key] = implode(", ", $_POST[$key]);

    }

}

?>

Okay, I have the checkbox group setup. I have not added the array code above because I am not sure where to place that in the page. I have a field in the table named PositionSignUp to place the checked positions.

thx
Eric

1) you have the names of the checkboxs set to be dynamic:
name="<?php echo $row_rsTours['trID']; ?>-VolunteerPosition"

this wont work, the checkbox names need to be static.

2) in the insert record behavior, bind the column you wish to store the checked values to the checkboxes.

3) after making the binding change, add [] to the end of the checkbox names

4) add the code i provided at line 1.

Ahhh! Okay, I follow that.


thx
Eric

That works perfectly! Thanks Jason!!