Incorporating select box with multiple selections

I'm nearly done with a registration type form I am working on.

I need to create a select list box where multiple selections can be made and sent to the database, the box may have 4-5 different options. Is there a way to incorporate this into the checkout form using ecart 5 or does this have to be hand coded in?


If hand coded, I may need a tutorial to follow if you know of one.

Thanks

make sure to name the select list ending in "[]", for example:
mySelect[]

this will create an array of the selected items.

then on the confirm page, create a hidden form element of the same name in the collection of hidden form elements using the implode function to convert the array to a comma separated list:

<input type="hidden" name="mySelect" value="<?php echo isset($_POST['mySelect'])?implode(", ",$_POST['mySelect']):""; ?>" />

now edit the store order summary behavior, bind the column that will store the selections to the hidden form element.

Thanks again Jason,

I still have a problem, when it writes to the database in the column assigned (InterestedIn) it is writing the word Array to the database, here is a portion of the code:

Checkout page where the form is located:

<select name="InterestedIn[]" id="InterestedIn" multiple="multiple" size="4">
<option value="DNO">Dad's Night Out</option>
<option value="Meet and Greet">Meet and Greet</option>
<option value="Friday Activity TBD">Friday Activity TBD</option>
<option value="All Activities">All Activities</option>
</select>

In the confirm.php page:

<input type="hidden" name="InterestedIn" value="<?php echo isset($_POST['InterestedIn'])?implode(", ",$_POST['InterestedIn']):""; ?>" />

I'm guessing I don't have something defined properly. In the post statement, is this where I would define the option like so:

php echo isset($_POST['DNO'])?implode

I am not receiving an error in the process.

send a copy of the checkout and confirm page please.

Here you go!

Ok, I see, the confirm page has the data set to store on post from the checkout page.

Double click the store order summary behavior, select the column that is storing the list values and edit the code for that column from:

<?php echo isset($_POST['InterestedIn'])?$_POST['InterestedIn']:""; ?>

to:

<?php echo isset($_POST['InterestedIn'])?implode(", ",$_POST['InterestedIn']):""; ?>

Hmmm, it is still just writing the word "Array" and not passing the values of the selection to the database.

send your latest copy of the confirm page.

Jason,

Here is the latest file.

add the following code at line 1 of the confirm page:

<?php

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

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

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

    }

}

?>