insert multiple option values into different columns (explode?)
I need to insert 2 values from a singe option into separate columns. How can I do this and not disable the gui on the plugin?
<select name="dc" id="dc">
<option value="">Select One</option>
<?php while(!$dc_options->atEnd()) { ?>
<option value="<?php echo($dc_options->getColumnVal("staff_id")); ?>,<?php echo($dc_options->getColumnVal("dow_id")); ?>">
<?php echo($dc_options->getColumnVal("first_name")); ?> <?php echo($dc_options->getColumnVal("last_name")); ?>'s - <?php echo($dc_options->getColumnVal("dow_name")); ?></option>
<?php $dc_options->moveNext(); } $dc_options->moveFirst(); //return RS to first record ?>
</select>
$InsertQuery->bindColumn("dc", "i", "".((isset($_POST["staff_id"]))?$_POST["staff_id"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("smallgroup_day", "i", "".((isset($_POST["dow"]))?$_POST["dow"]:"") ."", "WA_DEFAULT");