--- branches/paul/admin/include/insert.php 2004/03/18 19:58:18 68 +++ branches/paul_xx/admin/include/insert.php 2004/03/18 20:01:09 69 @@ -81,7 +81,7 @@ . ")"; // Write the new row to the database - if (mysql_tryquery($sql)) printf("Added Course Subject %s.", $coursesub_display); + if (xx_tryquery($sql)) printf("Added Course Subject %s.", $coursesub_display); } else printf("%s", $err_msg); @@ -145,7 +145,7 @@ . "')"; // Write the new row to the database - if (mysql_tryquery($sql)) printf("Added %s to the faculty table.", $faculty_name_display); + if (xx_tryquery($sql)) printf("Added %s to the faculty table.", $faculty_name_display); } else printf("%s", $err_msg); @@ -206,7 +206,7 @@ . "')"; // Write the new row to the database - if (mysql_tryquery($sql)) printf("Added Feature %s.", $feature_display); + if (xx_tryquery($sql)) printf("Added Feature %s.", $feature_display); } else printf("%s", $err_msg); @@ -267,7 +267,7 @@ . ")"; // Write the new row to the database - if (mysql_tryquery($sql)) printf("Added Information Type %s.", $infotype_display); + if (xx_tryquery($sql)) printf("Added Information Type %s.", $infotype_display); } else printf("%s", $err_msg); @@ -342,8 +342,8 @@ . ")"; // Write the new row to the database - mysql_tryquery ($sql); - $libunit_id = mysql_insert_id(); + xx_tryquery ($sql); + $libunit_id = xx_insert_id(); formLibunit($libunit_id); } else { @@ -438,7 +438,7 @@ . "')"; // Write the new row to the database - if (mysql_tryquery($sql)) printf("Added %s location.", $location_display); + if (xx_tryquery($sql)) printf("Added %s location.", $location_display); } else printf("%s", $err_msg); @@ -547,8 +547,8 @@ . "')"; // Write the new record to the database - mysql_tryquery ($sql); - $resource_id = mysql_insert_id(); + xx_tryquery ($sql); + $resource_id = xx_insert_id(); // Now set up this resource with its first mastersubject // Note that id#1 = N/A and id#2 = (All) are not used here. @@ -559,7 +559,7 @@ . $mastersubject_id . ")"; // Write the new res_mastersubject to the database - mysql_tryquery ($sql); + xx_tryquery ($sql); } // Call the formResource page back, in case user wants to edit further @@ -652,8 +652,8 @@ . "')"; // Write the new row to the database - mysql_tryquery ($sql); - $service_id = mysql_insert_id(); + xx_tryquery ($sql); + $service_id = xx_insert_id(); formService($service_id); } @@ -723,8 +723,8 @@ . $newValue . "')"; - mysql_tryquery ($sql); - $new_id = mysql_insert_id(); + xx_tryquery ($sql); + $new_id = xx_insert_id(); printf("%s %s successfully added.", $display, $newValue_display); } else printf ("%s", $err_msg); @@ -809,8 +809,8 @@ . "')"; // Write the new row to the database - mysql_tryquery ($sql); - $staff_id = mysql_insert_id(); + xx_tryquery ($sql); + $staff_id = xx_insert_id(); // Call staff form back formStaff($staff_id); @@ -884,7 +884,7 @@ . "')"; // Write the new row to the database - if (mysql_tryquery($sql)) printf("Added %s style.", $style_title_display); + if (xx_tryquery($sql)) printf("Added %s style.", $style_title_display); } else printf("%s", $err_msg); @@ -942,8 +942,8 @@ . ", now(), '" . $sess_staff_account . "')"; - mysql_tryquery ($sql); - $subject_id = mysql_insert_id(); + xx_tryquery ($sql); + $subject_id = xx_insert_id(); // Insert this staff person as an assigned staff member to this subject $sql = "INSERT INTO sub_staff (subject_id, staff_id) VALUES (" @@ -951,7 +951,7 @@ . ", " . $sess_staff_id . ")"; - mysql_tryquery($sql); + xx_tryquery($sql); formSubject($subject_id); } @@ -1022,7 +1022,7 @@ . "', '" . $vendor_status . "')"; - if (mysql_tryquery($sql)) printf("Added Vendor %s.", $vendor_display); + if (xx_tryquery($sql)) printf("Added Vendor %s.", $vendor_display); } else printf("%s", $err_msg);