I'm trying to update another table when I'm saving a record:
Code: Select all
$batID = $formValue['jbatch_id'];
nuRunQuery("UPDATE batch SET batch_maf = (SELECT SUM(jobs_fmaj) FROM jobs where jbatch_id='$batID' ) where batch_id ='$batID'");
nuRunQuery("UPDATE batch SET batch_mif = (SELECT SUM(jobs_fmin) FROM jobs where jbatch_id='$batID' ) where batch_id ='$batID'");
$faultsnum = nuRunQuery("SELECT * FROM batch WHERE batch_id = '$batID'");
$r=db_fetch_object($faultsnum);
$faultmaj = $r->batch_maf;
$faultmin = $r->batch_mif;
if ($faultmaj>0 || $faultmin>1){
$batST = 'Failed';
} else {
$batST = 'Passed';
}
nuRunQuery("UPDATE batch SET batch_status ='$batST' where batch_id ='$batID'");
But it doesn't work.
What I'm doing wrong????
Thank You,
Best Regards,
Rui