J'aimerais faire un INSERT Multiple avec DW, mais bon, apparemment il n'accepte qu'une entrée par champ !
Code
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO picking (lot_number, qte_pick, identification, treatment, date_exp, work_order, `ref`, designation, date_pick) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['scan0'], "text"),
GetSQLValueString($_POST['liste1'], "text"),
GetSQLValueString($_POST['identification0'], "text"),
GetSQLValueString($_POST['identification0'], "text"),
GetSQLValueString($_POST['expiration_date1'], "date"),
GetSQLValueString($_POST['work_order'], "text"),
GetSQLValueString($_POST['reference1'], "text"),
GetSQLValueString($_POST['designation1'], "text"),
GetSQLValueString($_POST['date'], "date"),
$insertSQL = sprintf("INSERT INTO picking (lot_number, qte_pick, identification, treatment, date_exp, work_order, `ref`, designation, date_pick) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['scan0'], "text"),
GetSQLValueString($_POST['liste1'], "text"),
GetSQLValueString($_POST['identification0'], "text"),
GetSQLValueString($_POST['identification0'], "text"),
GetSQLValueString($_POST['expiration_date1'], "date"),
GetSQLValueString($_POST['work_order'], "text"),
GetSQLValueString($_POST['reference1'], "text"),
GetSQLValueString($_POST['designation1'], "text"),
GetSQLValueString($_POST['date'], "date"),
J'aimerais donc, ajouter d'autres valeurs car j'ai plusieurs champs de même type mais avec des valeurs différentes.
Merci