"INSERT ... ON DUPLICATE KEY UPDATE" Syntax
Posted: Mon Apr 15, 2013 8:02 pm
Hi,
In "After Save" i run this code to modify a another table :
This works fine. Now i would like to change it into a "INSERT ... ON DUPLICATE KEY UPDATE" Syntax, but i can not get at it. Can anybody give me a helping hand?
Thanks.
In "After Save" i run this code to modify a another table :
Code: Select all
$sql = "INSERT INTO verbindung (";
$sql .= "formal_Erschliessung_ID)";
$sql .= "VALUES (";
$sql .= "'$recordID')";
nuRunQuery($sql);
Thanks.