--- branches/pear-db/admin/include/insert.php 2004/03/06 02:53:10 56 +++ branches/pear-db/admin/include/insert.php 2004/03/06 03:09:46 57 @@ -69,10 +69,8 @@ // Add only if this coursesub doesn't already exist, and something was supplied if ($err_code == 0) { - // Clean up strings - // Set up SQL - $sql = "INSERT INTO coursesub (coursesub, coursesub_descr, cip_code, campus_id) VALUES ( ? , ? , ? , ? )"; + $sql = "INSERT INTO coursesub (coursesub, coursesub_descr, cip_code, campus_id) VALUES ( ? , ? , ? , ? )"; // Write the new row to the database if (!xx_prepare_execute($sql, $coursesub, $coursesub_descr, $cip_code, $campus_id)){ @@ -146,7 +144,7 @@ sql_err($con); xx_query ("UNLOCK TABLES", $con); bailout(); - } + } else { printf("Added %s to the faculty table.
\n", $faculty_name_display); xx_query("UNLOCK TABLES", $con); @@ -210,7 +208,7 @@ sql_err($con); xx_query ("UNLOCK TABLES", $con); bailout(); - } + } else { printf("Added Feature %s.
", $feature_display); xx_query("UNLOCK TABLES", $con); @@ -357,7 +355,7 @@ sql_err($con); xx_query ("UNLOCK TABLES", $con); bailout(); - } + } else { // $libunit_id = xx_insert_id($con) $insert_res = xx_prepare_execute("select 1 as id from libunit where libunit = ? and libunit_abbrev = ? and head_staff_id = ?", $libunit, $libunit_abbrev, $head_staff_id); @@ -596,7 +594,7 @@ // Clean up strings // Build the SQL - $sql = "INSERT INTO ? ( ? ) VALUES ( ? )"; + $sql = "INSERT INTO ! ( ! ) VALUES ( ? )"; // Debugging // printf("sql was: %s
", $sql);