nuBuilder Forum

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);