0){ $updateKRA = "UPDATE `mar_actions_data` SET `action_date`='$selActionDate', `action_person`='$selActionPerson', `deleted`='$isDeleted' WHERE `emp_record_id` = '$getEmpRecordID' AND `action_id`='$selActionID' AND `mar_header_id`='$getMarHeader'"; if ($conn->query($updateKRA) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } }else{ $sql = "INSERT INTO mar_actions_data ( `id`, `emp_record_id`, `mar_header_id`, `action_id`, `action_value`, `action_date`, `action_person`, `date_added`, `added_by` ) VALUES ('', '$getEmpRecordID', '$getMarHeader', '$selActionID', $isCheck, '$selActionDate', '$selActionPerson', '$myTimeStamp', '$userID')"; if ($conn->query($sql) === TRUE) { } else { } } $conn->close(); } ?>