Need to INSERT into other table After Execute Update event for editable grid

Quote :

global $ed_grid_form;

//Current Date/Time
$current_date = date('Y-m-d H:i:s');

//DB connections
$DBinsert_historic_values = new clsMyConn();
$DBselect_current_values = new clsMyConn();
$DBselect_historic_values = new clsMyConn();

//Select current value relative to the current ED GRID ROW
$sql = "SELECT code, cost FROM current_table WHERE code = " . $ed_grid_form->code_hidden->getValue();
$DBselect_current_values->query($sql);
$DBselect_current_values->next_record();

//Select historic value with NEWEST DATE relative to the current ED GRID ROW
$sql = "SELECT code, cost FROM historic_table WHERE code = " . $ed_grid_form->code_hidden->getValue() . " ORDER BY date DESC LIMIT 1";
$DBselect_historic_values->query($sql);
$DBselect_historic_values->next_record();

//Compares the CURRENT value with the HISTORIC value
//Only if values are different a new INSERTION at the history table will occur
if ($DBselect_current_values->f("cost") != $DBselect_historic_values->f("cost")) {
$sql = "INSERT INTO historic_table (code, date, cost) VALUES (". $ed_grid_form->code_hidden->getValue() . ", '" . $current_date . "', " . $ed_grid_form->cost->getValue() . ")";
$DBinsert_historic_values->query($sql);
}

//Free the connections
unset($DBinsert_historic_values);
unset($DBselect_current_values);
unset($DBselect_historic_values);