Using multiple link transactions in Dreamweaver / ADDT

// Make an update transaction instance
$upd_mastertable = new tNG_update($conn_database_name);
$tNGs->addTransaction($upd_mastertable);
// Register triggers
$upd_mastertable->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Update1");
$upd_mastertable->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
//$upd_mastertable->registerTrigger("END", "Trigger_Default_Redirect", 99, "part2.php");
$upd_mastertable->registerTrigger("AFTER", "Trigger_LinkTransactions", 98);
$upd_mastertable->registerTrigger("ERROR", "Trigger_LinkTransactions", 98);
$upd_mastertable->registerTrigger("AFTER", "Trigger_LinkTransactions1", 98);
$upd_mastertable->registerTrigger("ERROR", "Trigger_LinkTransactions1", 98);
$upd_mastertable->registerTrigger("AFTER", "Trigger_LinkTransactions2", 98);
$upd_mastertable->registerTrigger("ERROR", "Trigger_LinkTransactions2", 98);
// Add columns
$upd_mastertable->setTable("mastertable");
$upd_mastertable->addColumn("open_app", "NUMERIC_TYPE", "POST", "open_app");
$upd_mastertable->addColumn("already_applied", "STRING_TYPE", "POST", "already_applied");
$upd_mastertable->setPrimaryKey("user_id", "NUMERIC_TYPE", "SESSION", "kt_login_id");
 
// Make an insert transaction instance
$ins_secondary_table1 = new tNG_insert($conn_database_name);
$tNGs->addTransaction($ins_secondary_table1);
// Register triggers
$ins_secondary_table1->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert3");
//$ins_secondary_table1->registerTrigger("END", "Trigger_Default_Redirect", 99, "part2.php");
// Add columns
$ins_secondary_table1->setTable("secondary_table1");
$ins_secondary_table1->addColumn("table1_login_usr", "NUMERIC_TYPE", "SESSION", "kt_login_id", "");
$ins_secondary_table1->setPrimaryKey("table1_id", "NUMERIC_TYPE");
 
// Make an insert transaction instance
$ins_secondary_table2 = new tNG_insert($conn_database_name);
$tNGs->addTransaction($ins_secondary_table2);
// Register triggers
$ins_secondary_table2->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert3");
//$ins_secondary_table2->registerTrigger("END", "Trigger_Default_Redirect", 99, "part2.php");
// Add columns
$ins_secondary_table2->setTable("secondary_table2");
$ins_secondary_table2->addColumn("table2_login_usr", "NUMERIC_TYPE", "SESSION", "kt_login_id", "");
$ins_secondary_table2->setPrimaryKey("table2_id", "NUMERIC_TYPE");
 
// Make an insert transaction instance
$ins_secondary_table3 = new tNG_insert($conn_database_name);
$tNGs->addTransaction($ins_secondary_table3);
// Register triggers
$ins_secondary_table3->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert3");
$ins_secondary_table3->registerTrigger("END", "Trigger_Default_Redirect", 99, "part2.php");
// Add columns
$ins_secondary_table3->setTable("secondary_table3");
$ins_secondary_table3->addColumn("table3_login_usr", "NUMERIC_TYPE", "SESSION", "kt_login_id", "");
$ins_secondary_table3->setPrimaryKey("table3_id", "NUMERIC_TYPE");
 
// Execute all the registered transactions
$tNGs->executeTransactions();
 
// Get the transaction recordset
$rsmastertable = $tNGs->getRecordset("mastertable");
$row_rsmastertable = mysql_fetch_assoc($rsmastertable);
$totalRows_rsmastertable = mysql_num_rows($rsmastertable);
 
// Get the transaction recordset
$rssecondary_table3 = $tNGs->getRecordset("secondary_table3");
$row_rssecondary_table3 = mysql_fetch_assoc($rssecondary_table3);
$totalRows_rssecondary_table3 = mysql_num_rows($rssecondary_table3);
 
// Get the transaction recordset
$rssecondary_table2 = $tNGs->getRecordset("secondary_table2");
$row_rssecondary_table2 = mysql_fetch_assoc($rssecondary_table2);
$totalRows_rssecondary_table2 = mysql_num_rows($rssecondary_table2);
 
// Get the transaction recordset
$rssecondary_table1 = $tNGs->getRecordset("secondary_table1");
$row_rssecondary_table1 = mysql_fetch_assoc($rssecondary_table1);
$totalRows_rssecondary_table1 = mysql_num_rows($rssecondary_table1);
?>
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75: