PHP - Multiple Selection In An Option List

if a user were to select multiple items in a selection list I would like to concatenate those items into a list and assign that into a variable. I know I should loop through the list but i'm not sure how I would continue to add those values to a variable.

Hi

I am pulling my hair out over this, I have tried many many ways on getting this to work but none have.

I have a multi list selection box, which the user can select more than one option from. Once submitted this gets sent to a mysql database table.

Below is my shortened version of the multi list html code:

<select multiple="multiple" size="10" name="special[]">
<option value="Abdominal Training"> Abdominal Training </option>
                        <option value="Aerobics"> Aerobics </option>
                        <option value="Agility"> Agility </option>

</select>


If have tried putting  [] which creates an array in the mysql table field special, but when I echo it back it just echos 'array'.

When I try it without the [], and echo it back, it only echos one selection.

I am still new to php, but have managed to get my head around a lot, but have been stuck on this for weeks, please help.

I'm trying to get this drop down menu to be sticky once the user clicks submit. 

Here's my entry code:
Code: [Select]
if (isset($_POST['guess']))
{
    if ($_POST['guess'] == $_SESSION['number'])
    {
        $response = "You Win!";
        unset($_SESSION['number']);
    }
    else
    {
        $_SESSION['tries']++;
       
        if ($_SESSION['tries'] < 3)
        {
            $response = "Try #{$_SESSION['tries']}<br /><br />";
        }
        else
        {
            $response = "You Lose";
            unset($_SESSION['number']);
        }
    }
}

if (empty($_SESSION['number']))
{
    $_SESSION['tries'] = 0;
    $_SESSION['number'] = rand(1, 10);
}
And in my body:

Code: [Select]
<select name="guess" id="guess">
                <?php
                
                for ($i = 1; $i < 11; $i++)
                {
                    echo "<option value='{$i}'>{$i}</option>";
                }
                
                ?>
            </select>

Hey guys, i have a small problemo. As you can see i have made an option list from 0 to 3.

How can I put this optionlist in a for loop so I can save some place? I have found an example but I dont know how to integrate it in my php
Example
Code: [Select]
for( $i = 0; $i < 4; $i++ ) {
$optionlist .= "<option value=\"$i\">$i</option>\n";
}
$optionlist .= "</select>\n";

Code: [Select]
        <?php
        $dranken = array("cola", "fanta", "bier", "koffie", "thee");
        $prijzen = array("2", "2", "1.80", "2.20", "2.20");


        $i = 0;

        echo "<table>";

        while ($dranken[$i]) {
            $listnaam = $dranken[$i] . "_aantal";
            $optionlist = "<select name= '$listnaam'><option>0</option><option>1</option><option>2</option><option>3</option></select>";
            
            echo "<tr><td >" . $dranken[$i] . "</td>";
            echo "<td>" . $prijzen[$i] . "</td>";
echo "<td>" . $optionlist . "</td></tr>";

            $i++;
        }

        echo "</table>";
        ?>


thanks

When I try to select more than one value for my report, only one value shows.  I tried a few things, but I'm not having any luck.

Here is the form code:
Code: [Select]
<td style="text-align: right">Job Type:</td>
<td>
<select name="job_type" multiple="multiple" size="3">
<option value="0" selected>ALL</option>
{section name=jt loop=$job_type_list}
<option value="{$job_type_list[jt][0]}">{$job_type_list[jt][1]}</option>
{/section}
</select>
</td>
Here is the other code:
//All IIS Object Code is to be encapsulated in the execute_object function
function execute_object($tab){
if ((isset($_POST['job']) and
 isset($_POST['job_type']) and
 isset($_POST['child_type']) and
 isset($_POST['job_status']) and
 isset($_POST['child_status']) and
 isset($_POST['ou']) and
 isset($_POST['child_ou']) and
 isset($_POST['pm']) and
 isset($_POST['child_pm']) and
 isset($_POST['dm']) and
 isset($_POST['child_dm']) and
 isset($_POST['customer']) and
 isset($_POST['end_date'])) or
(isset($_SESSION['report_job']) and
 isset($_SESSION['report_job_type']) and
 isset($_SESSION['report_child_type']) and
 isset($_SESSION['report_job_status']) and
 isset($_SESSION['report_child_status']) and
 isset($_SESSION['report_ou']) and
 isset($_SESSION['report_child_ou']) and
 isset($_SESSION['report_pm']) and
 isset($_SESSION['report_child_pm']) and
 isset($_SESSION['report_dm']) and
 isset($_SESSION['report_child_dm']) and
 isset($_SESSION['report_customer']) and
 isset($_SESSION['report_end_date'])))
 {
 //Include functions
include $GLOBALS['include_path']."penta.job.functions.php";
include $GLOBALS['include_path']."display.functions.php";
include $GLOBALS['include_path']."report.functions.php";

//Get report parameters
if (isset($_POST['job'])){
$job_id = $_POST['job'];
} else {
$job_id = $_SESSION['report_job'];
}
if (isset($_POST['job_type'])){
$job_type = $_POST['job_type'];
} else {
$job_type= $_SESSION['report_job_type'];
}
if (isset($_POST['child_type'])){
$child_type = $_POST['child_type'];
} else {
$child_type= $_SESSION['report_child_type'];
}
if (isset($_POST['exclude_type'])){
$exclude_type = 1;
} else {
if(isset($_SESSION['report_exclude_type'])){
$exclude_type = $_SESSION['report_exclude_type'];
} else {
$exclude_type = 0;
}
}
if (isset($_POST['job_status'])){
$job_status = $_POST['job_status'];
} else {
$job_status= $_SESSION['report_job_status'];
}
if (isset($_POST['child_status'])){
$child_status = $_POST['child_status'];
} else {
$child_status= $_SESSION['report_child_status'];
}
if (isset($_POST['ou'])){
$ou_id = $_POST['ou'];
} else {
$ou_id = $_SESSION['report_ou'];
}
if (isset($_POST['child_ou'])){
$child_ou_id = $_POST['child_ou'];
} else {
$child_ou_id = $_SESSION['report_child_ou'];
}
if (isset($_POST['pm'])){
$pm_id = $_POST['pm'];
} else {
$pm_id = $_SESSION['report_pm'];
}
if (isset($_POST['child_pm'])){
$child_pm_id = $_POST['child_pm'];
} else {
$child_pm_id = $_SESSION['report_child_pm'];
}
if (isset($_POST['dm'])){
$dm_id = $_POST['dm'];
} else {
$dm_id = $_SESSION['report_dm'];
}
if (isset($_POST['child_dm'])){
$child_dm_id = $_POST['child_dm'];
} else {
$child_dm_id = $_SESSION['report_child_dm'];
}
if (isset($_POST['customer'])){
$cus_id = $_POST['customer'];
} else {
$cus_id = $_SESSION['report_customer'];
}
if (isset($_POST['sort_by_cust'])){
$sort_by_cust = 1;
} else {
if(isset($_SESSION['report_sort_by_cust'])){
$sort_by_cust = $_SESSION['report_sort_by_cust'];
} else {
$sort_by_cust = 0;
}
}
if (isset($_POST['end_date'])){
$edate = $_POST['end_date'];
} else {
$edate = $_SESSION['report_end_date'];
}
$job_type = implode(",",$_POST['job_type']);
//Prepare to output report
$filename = "Project Review Report.xls";
if (isset($_POST['print'])){
//Prepare the output file
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"$filename\"");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
header("Pragma: public");
} else {
//Save the report parameters to enable printing from the preview
$_SESSION['report_job'] = $job_id;
$_SESSION['report_job_type'] = $job_type;
$_SESSION['report_child_type'] = $child_type;
$_SESSION['report_exclude_type'] = $exclude_type;
$_SESSION['report_job_status'] = $job_status;
$_SESSION['report_child_status'] = $child_status;
$_SESSION['report_ou'] = $ou_id;
$_SESSION['report_child_ou'] = $child_ou_id;
$_SESSION['report_pm'] = $pm_id;
$_SESSION['report_child_pm'] = $child_pm_id;
$_SESSION['report_dm'] = $dm_id;
$_SESSION['report_child_dm'] = $child_dm_id;
$_SESSION['report_customer'] = $cus_id;
$_SESSION['report_sort_by_cust'] = $sort_by_cust;
$_SESSION['report_end_date'] = $edate;
//Output a print button at the start of the preview
preview_print_button("load_object.php?&object=52.2");
}
    
//Get the list of jobs based on the given criteria
$job_list = report_job_list($job_id, $job_type, $child_type, $exclude_type, $job_status, $child_status, $ou_id, $child_ou_id, $pm_id, $child_pm_id, $dm_id, $child_dm_id, $cus_id, $sort_by_cust, $selected_by);
//Set the max script execution time to ensure it can finish based on the number of jobs
$num_jobs = $job_list->RecordCount();
set_time_limit(60 + ($num_jobs * 30));

//Parse the template
$template = $GLOBALS['reports_path']."report52.2.htm";
$default_logo = "report52.2_files/image001.gif";
$hdr = null; $ftr = null;
parse_template($template, $default_logo, $hdr, $ftr);