--- 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);