Put
nuSetHash('LogModDate',date());
into JavaScript side, meaning before PHP event calls g.e. nuOnSave())
function nuOnSave() {
nuSetHash('LogModDate',date());
}
then on your PHP code, you can use the Hash as
$s = "
UPDATE inventory
SET inventory_log_TN_modified_by = '#nu_user_name#'
SET inventory_log_modified_at = '#LogModDate#'
WHERE INVENTRORY_ID = '#RECORD_ID#'
";
nuRunQuery($s);
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.