This block of code is ADO connection code used only for demonstration purposes objConn is an ADO object we use here for demonstration purposes. */ $saveHandler = new EBASaveHandler(); $saveHandler->ProcessRecords(); // Make a MySQL Connection mysql_connect() or die(mysql_error()); mysql_select_db("nitobi_testdb_v1") or die(mysql_error()); // ********************************************************** ' // Begin by processing our inserts // ********************************************************** ' $insertCount = $saveHandler->ReturnInsertCount(); if ($insertCount > 0) { // Yes there are INSERTs to perform... for ($currentRecord = 0; $currentRecord < $insertCount; $currentRecord++) { $myQuery = "INSERT INTO tblorders (CustomerID, ProductName, OrderDate, ShippedDate) VALUES (" . "'" . $saveHandler->ReturnForeignKeyValue($currentRecord) . "'," . "'" . $saveHandler->ReturnInsertField($currentRecord, "ProductName") . "', " . "'" . $saveHandler->ReturnInsertField($currentRecord, "OrderDate") . "', " . "'" . $saveHandler->ReturnInsertField($currentRecord, "ShippedDate") . "'" . "); "; // Now we execute this query mysql_query($myQuery); } } // ********************************************************** ' // Continue by processing our updates // ********************************************************** ' $updateCount = $saveHandler->ReturnUpdateCount(); if ($updateCount > 0) { // Yes there are UPDATEs to perform... for ($currentRecord = 0; $currentRecord < $updateCount; $currentRecord++) { $myQuery = "UPDATE tblorders SET " . "ProductName\t\t= '" . $saveHandler->ReturnUpdateField($currentRecord, "ProductName") . "', " . "OrderDate\t\t\t= '" . $saveHandler->ReturnUpdateField($currentRecord, "OrderDate") . "', " . "ShippedDate\t\t\t= '" . $saveHandler->ReturnUpdateField($currentRecord, "ShippedDate") . "'" . "WHERE OrderID \t= " . $saveHandler->ReturnUpdateField($currentRecord) . "" . ";"; // Now we execute this query mysql_query($myQuery); }