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!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.