} else { $nProvinceIssued = new EBPLSProvince($dbLink, 'false'); $nProvinceIssued->searchcomp($bbo, $iProvince); $ifexist = $nProvinceIssued->rcount; if ($ifexist > 0) { ?> <body onload='javascript:alert ("Existing Province Found!!");'></body> <?php } else { $datetoday = date("Y-m-d H:i:s"); $nProvinceIssued = new EBPLSProvince($dbLink, 'false'); $nProvinceIssued->setData(PROVINCE_DESC, addslashes($iProvince)); $nProvinceIssued->setData(PROVINCE_DATE_UPDATED, $datetoday); $nProvinceIssued->setData(UPDATED_BY, $usern); $nProvinceIssued->setData(BLGF_CODE, $iBLGFCode); $nProvinceIssued->update($bbo); $bbo = ""; $iProvince = ""; $iBLGFCode = ""; ?> <body onload='javascript:alert ("Record Successfully Updated!!");'></body> <?php } } } elseif ($confx == 1) { $check1 = mysql_query("select * from ebpls_owner where owner_province_code = '{$bbo}'"); $check1 = mysql_num_rows($check1); $check2 = mysql_query("select * from ebpls_business_enterprise where business_province_code = '{$bbo}'"); $check2 = mysql_num_rows($check2); if ($check1 > 0 || $check2 > 0) { ?>