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!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.