Submitting multiple selection to mysql DB
select name="task_7[]" multiple>
<option value="NONE">NONE</option>
<option value="ALL">ALL</option>
<option value="ALL CHE">ALL CHE</option>
<option value="ALL PTK">ALL PTK</option>
<option value="CENTRAL">CENTRAL</option>
<option value="CHE C/W">CHE C/W</option>
<option value="CHE E/N">CHE E/N</option>
<option value="CORR_NTH">CORR_NTH</option>
<option value="CORR_REG">CORR_REG</option>
<option value="CORR_STH">CORR_STH</option>
<option value="EAST">EAST</option>
<option value="LUNCH">LUNCH</option>
<option value="NORTH">NORTH</option>
<option value="PROJECT">PROJECT</option>
<option value="PTK C/N/R">PTK C/N/R</option>
<option value="PTK E/W">PTK E/W</option>
<option value="REGIONS">REGIONS</option>
<option value="RIDE_OUT">RIDE_OUT</option>
<option value="TRAINING">TRAINING</option>
<option value="WEST">WEST</option>
</select>
------------------------------------------------------
$query = "insert into table_name values ('".$task_7."', '".$task_8."')";
$result = $db->query($query);
if ($result)
print $db->affected_rows. ' Schedule added into database. ';
$db->close();
-------------------------------
Data is posted but only one selection is posted from the form.
|
