UPDATE `comp_acc_det` SET `amountdr` = amountdr +2823.41, `amountcr` = amountcr +0, `total` = amountdr - amountcr, `updatedBy` = '43' WHERE `companyID` =  '95' AND `acctID` =  '28438' AND `year` =  '2013' AND `period` =  '1'