Thanks Ray, yes the standard insert worked fine accepting an array which required making the checkbox name with the square braces[].
The Dynamic checkbox select if equal to did not work as well as it kept inserting independent values with each test:
<input
<?php if (!(strcmp(($Companies->getColumnVal("companyID")),$Companies_assigned->getColumnVal('psaCompany')))) {echo "checked=\"checked\"";} ?>
<?php if (!(strcmp(($Companies_assigned->getColumnVal("psaCompany")),"Y"))) {echo "checked=\"checked\"";} ?>
<?php if (!(strcmp(($Companies_assigned->getColumnVal("psaProject")),"$Companies->getColumnVal(\'companyID\')"))) {echo "checked=\"checked\"";} ?>
type="checkbox"
name="CheckboxGroup1_<?php echo($wa_startindex); ?>"
value="<?php echo($Companies->getColumnVal("companyID")); ?>"
id="CheckboxGroup1_<?php echo($Companies->getColumnVal('companyID')); ?>_<?php echo($wa_startindex); ?>">
This was easiliy surmounted by putting the recordset in an array and using the PHP in_array function:
<input <?php if (in_array($Companies->getColumnVal("companyID"),$nameArray)) {
echo "checked=\"checked\"";
} ?>
type="checkbox"
name="CheckboxGroup1[]"
value="<?php echo($Companies->getColumnVal("companyID")); ?>"
id="CheckboxGroup1_<?php echo($Companies->getColumnVal('companyID')); ?>">