sql server - php script enters duplicate data in database -


i have php script runs stored procedure sql server , enters data in table present in database. when run php script enters duplicate date same data present in database. need rid of these duplicate data. stored procedure gives me correct output php script troubling me

     while ($obj = sqlsrv_fetch_array( $stmt, sqlsrv_fetch_assoc  )) {       if($obj['bank_name']!= $obj['bank_name_old'])             {                    $obj['company_code'];              $obj['account_code'];             $obj['bank_name'];              $obj['bank_name_old'];             $obj['field_name']='bank name';               if($obj['field_name']='bank name')             {                    $old=$obj['bank_name_old'];                      $new=$obj['bank_name'];              }                     $query="insert vns_db.dbo.client_details_log (company_code,client_id,field_name,original_value,new_value) values ('".$obj['company_code']."',                             '".$obj['account_code']."','".$obj['field_name']."','$old','$new')";                                 $res = sqlsrv_query($conn,$query);                             //$obj['modified_fields']=$obj['field_name'].'|'.addslashes('$old').'|'.addslashes('$new');                          //  echo $query;             }            if($obj['bank_acno'] != $obj['bank_acno_old'])             {                      $obj['company_code'];                       $obj['account_code'];                      $obj['bank_acno'];                       $obj['bank_acno_old'];                      $obj['field_name']='bank account number';                          if($obj['field_name']='bank account number')             {                        $old=$obj['bank_acno_old'];                      $new=$obj['bank_acno'];                      }                      $query="insert vns_db.dbo.client_details_log (company_code,client_id,field_name,original_value,new_value) values ('".$obj['company_code']."',                             '".$obj['account_code']."','".$obj['field_name']."','$old','$new')";                              $res = sqlsrv_query($conn,$query);                             //$obj['modified_fields']=$obj['field_name'].'|'.addslashes('$old').'|'.addslashes('$new');                             //echo $query;              }    

there possibility of execution of both if conditions in loop:

if($obj['bank_name']!= $obj['bank_name_old']) 

and

if($obj['bank_acno'] != $obj['bank_acno_old']) 

this might run insertion 2 times tryout :)


Comments

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

SVG stroke-linecap doesn't work for circles in Firefox? -

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -