Example #1
0
                         }
                         $insertreq = mysql_query("insert into fee_exempt values\t('', '{$ownership_code}',\t{$getr['0']}, {$s})") or die("ins");
                         //	echo "insert into fee_exempt values	('', '$ownership_code',	$getr[0], $s)";
                     }
                 }
             }
             $Submit = "";
             ?>
                 <body onload='javascript:alert ("Data is successfully added to the database.");'></body>
                 <?php 
         }
     }
 } else {
     if ($com == 'edit') {
         $nUpdOwnType = new Ownership();
         $nUpdOwnType->UpdateQuery('ebpls_business_category', $ownership_code, $ownership_type, $usern, $exemption, $engcode);
         $xc = 0;
         $i = 1;
         while ($xc < $howmany) {
             $ic++;
             if ($x[$i] == 'on') {
                 $s = 1;
             } else {
                 $s = 0;
             }
             ///VooDoo
             $check1 = mysql_query("select * from fee_exempt where\n                                        business_category_code='{$ownership_code}'\n                                        and tfoid='{$colls[$i]}'") or die("c" . mysql_error());
             $hreq = mysql_num_rows($check1);
             if ($hreq == 0) {
                 $insertreq = mysql_query("insert into fee_exempt values ('', '{$ownership_code}', '{$colls[$i]}', '{$s}')") or die("ins");
             } else {