require 'includes/variables.php'; include 'lib/phpFunctions-inc.php'; include 'class/province.class.php'; if ($sb == 'Submit') { $bcode = str_replace(" ", " ", trim($bcode)); $nQuery = "select * from {$preft} where {$prefd}='{$bcode}'"; echo $nQuery; $nProvince = new Province(); $nProvince->Query1($nQuery); $nRecord = $nProvince->dbResultOut; if ($nRecord == 0) { $bname = strtoupper($bname); $sQuery = "select * from {$preft} where {$prefc}='{$bname}' and blgf_code='{$blgf_codes}'"; $nProvince = new Province(); $nProvince->Query1($sQuery); $chkDuplicate = $nProvince->dbResultOut; if ($chkDuplicate == 0) { $dQuery = "insert into {$preft} values ('{$bname}', '{$bname}',now(),now(),'{$usern}', '{$blgf_codes}')"; $nProvince = new Province(); $nProvince->InsertQuery($preft, $dQuery); ?> <body onLoad='javascript:alert("Record Successfully Saved");'></body> <?php } else { ?> <body onload='javascript:alert("Duplicate Record Found");'></body> <?php // echo "<div align=center>DUPLICATE RECORD</div>"; } } elseif ($com == 'edit') {