$mprimarykey = $this->getParam("mprimarykey");
$mforeignkey = $this->getParam("mforeignkey");
if ($doSave == "yes") {
if (is_array($multiselectfield)) {
$this->setLog("\n multiselect field Array found with " . count($multiselectfield) . " records");
foreach ($multiselectfield as $ext_table_name) {
$fieldname = $mprimarykey[$ext_table_name];
if (strlen($this->getParam($fieldname)) > 0) {
$fieldvalue = $this->getParam($fieldname);
} else {
$fieldvalue = $this->getParam("insertid");
$this->setLog("\n insert id :" . $fieldvalue);
}
$this->setLog("\n processing field: " . $ext_table_name);
$q_del = new sqlQuery($this->getDbCon());
$q_del->query("delete from " . $ext_table_name . " where " . $fieldname . "='" . $fieldvalue . "'");
$q_del->free();
$q_ins_new = new sqlQuery($this->getDbCon());
if (is_array($multiselectvalues[$ext_table_name])) {
$this->setLog("\n multiselectvalues field Array found with " . count($multiselectvalues[$ext_table_name]) . " records");
foreach ($multiselectvalues[$ext_table_name] as $value) {
$q_ins_new->query("insert into " . $ext_table_name . " ({$fieldname}, " . $mforeignkey[$ext_table_name] . ") values ('" . $fieldvalue . "', '" . $value . "')");
$this->setLog("\n" . $q_ins_new->getSqlQuery());
}
}
$q_ins_new->free();
}
}
}
$this->setLog("\n --- End mydb.formatMultiSelectField ");
$this->setLogRun(false);
