PHPRunner 6.0 manual - Events. Save old data in another table

To save old data in another table use Save old data record in another table action.

Available in following events:

·	Edit page: Before record updated;

·	List page: Before record deleted.

step11-1-9

Note: Change the values listed in red to match your specific needs.

//********** Save old data record in another table ************

global $conn,$strTableName;

$strSQLSave = "INSERT INTO AnotherTable (Field1, Field2)

SELECT Field1, Field2 FROM ".$strTableName." where ".$where;

db_exec($strSQLSave,$conn);