When i click on View, i need the current record should populate with current date/time. But following is not working:
ServerEvents->TableSpecific->ViewPage->Page_Load
ExecuteScalar("update first_status_changed set converted = NOW()
WHERE customer_id = '" . $rsold['customer_id']. "' ");
facing following error:
Notice: Undefined variable: rsold in C:\xampp\htdocs\mip2019\classes\submissions_view.php on line 1790
Notice: Undefined variable: rsold in C:\xampp\htdocs\mip2019\classes\submissions_view.php on line 1793
please suggest any idea.