|
OK, Changed it to Before Edit, Save new data in another table: global $conn,$strTableName; $strSQLSave = "INSERT INTO term_history (TerminalID, Merchant_Name, MID_Number, terminal_type, Assigned_S_N, Swap_s_n, softwareversion, pinpad, Sim, assigned_date) values ("; $strSQLSave .= $values["--rbegin--TerminalID--rend--"].",";
$strSQLSave .= $values["Merchant_Name"].",";
$strSQLSave .= $values["--rbegin--MID_Number--rend--"].",";
$strSQLSave .= $values["--rbegin--terminal_type--rend--"].",";
$strSQLSave .= $values["--rbegin--Assigned_S_N--rend--"].",";
$strSQLSave .= $values["--rbegin--Swap_s_n--rend--"].",";
$strSQLSave .= $values["--rbegin--Assigned_S_N--rend--"].",";
$strSQLSave .= $values["--rbegin--softwareversion--rend--"].",";
$strSQLSave .= $values["--rbegin--pinpad--rend--"].",";
$strSQLSave .= $values["--rbegin--Sim--rend--"].",";
$strSQLSave .= $values["--rbegin--softwareversion--rend--"].",";
$strSQLSave .= $values["assigned_date"]; $strSQLSave .= ")";
db_exec($strSQLSave,$conn); Getting error: Error type 256
Error description You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'i7910,37900810-25881996,37900810-25881987,37900810-25881996,6.04,30500820-938023' at line 1
URL portal.swiftpayment.ca/Terminal_Swaps_edit.php?
Error file /home/ashumak/portal/include/dbconnection.php
Error line 36
SQL query INSERT INTO term_history (TerminalID, Merchant_Name, MID_Number, terminal_type, Assigned_S_N, Swap_s_n, softwareversion, pinpad, Sim, assigned_date) values (32400000,SWIFTPAYMENT,,i7910,37900810-25881996,37900810-25881987,37900810-25881996,6.04,30500820-93802305,,6.04,2011-05-26) Call stack
File: line Function Arguments
0. include/dbconnection.php:36 db_query 1. INSERT INTO term_history (TerminalID, Merchant_Name, MID_Number, terminal_type, Assigned_S_N, Swap_s_n, softwareversion, pinpad, Sim, assigned_date) values (32400000,SWIFTPAYMENT,,i7910,37900810-25881...;
- Resource id #11;
1. include/dbconnection.php:47 db_exec 1. INSERT INTO term_history (TerminalID, Merchant_Name, MID_Number, terminal_type, Assigned_S_N, Swap_s_n, softwareversion, pinpad, Sim, assigned_date) values (32400000,SWIFTPAYMENT,,i7910,37900810-25881...;
- Resource id #11;
2. include/Terminal_Swaps_events.php:180 eventclass_Terminal_Swaps->BeforeEdit 1. Array ( [TerminalID] => 32400000 [MID_number] => 3240000000 [Merchant_Name] => SWIFTPAYMENT [terminal_type] => i7910 [Assigned_S_N] => 37900810-25881996 [softwareversion] => 6....;
- TID_ID=1;
- Array ( [TID_ID] => 1 [TerminalID] => 32400000 [MID_number] => 3240000000 [Merchant_Name] => SWIFTPAYMENT [terminal_type] => i7910 [Assigned_S_N] => 37900810-25881996 [soft...;
- Array ( [TID_ID] => 1 ) ;
- ;
- ;
3. Terminal_Swaps_edit.php:546 Global scope N/A
Any suggestions on this? Alan
|