{ foreach($couples as $key => $val) { $sql ="INSERT INTO ".MAIN_DB_PREFIX."categorie_association(fk_categorie_mere,fk_categorie_fille)"; $sql.=" VALUES(".$val['mere'].", ".$val['fille'].")"; dolibarr_install_syslog("upgrade: insert association sql=".$sql); $resqli=$db->query($sql); if (! $resqli) $error++; } } if (! $error) { print '<tr><td>'.$langs->trans("RemoveDuplicates").'</td>'; print '<td align="right">'.$langs->trans("Success").' ('.$num.'=>'.sizeof($couples).')</td></tr>'; $db->commit(); } else { print '<tr><td>'.$langs->trans("RemoveDuplicates").'</td>'; print '<td align="right">'.$langs->trans("Failed").'</td></tr>'; $db->rollback(); } } } else { print '<div class="error">'.$langs->trans("Error").'</div>'; } /*