$tblAddress['Address_Lon'] = $lon; $ClassMaster->insert('tblAddress', $tblAddress); $Address_Id = $ClassMaster->LastID(); $tblClass['Company_Id'] = $_POST['Company_Id']; $tblClass['Address_Id'] = $Address_Id; if ($new_filename != '') { $new_filename = "http://ClassCrashers.wheresthepen.com/uploads/" . $new_filename; $tblClass['Class_Photo'] = $new_filename; } $tblClass['Class_Time'] = $_POST['txtOpenTimeHr'] . ":" . $_POST['txtOpenTimeMn'] . " " . $_POST['txtOpenTimeAMPM'] . " - " . $_POST['txtCloseTimeHr'] . ":" . $_POST['txtCloseTimeMn'] . " " . $_POST['txtCloseTimeAMPM']; if ($_POST['class_id'] == '') { $ClassMaster->insert('tblClass', $tblClass); $Class_Id = $ClassMaster->LastID(); } else { $Class_Id = mysqli_real_escape_string($ClassMaster->link(), $_POST['class_id']); $ClassMaster->update('tblClass', $tblClass, "Class_Id = '" . $Class_Id . "'"); } $ClassMaster->query("DELETE FROM tblInstructorClassXref WHERE Class_Id = '" . $Class_Id . "'"); foreach ($Instructors as $Instructor) { $tblInstructorClassXref['Instructor_ID'] = $Instructor; $tblInstructorClassXref['Class_Id'] = $Class_Id; $ClassMaster->insert('tblInstructorClassXref', $tblInstructorClassXref); } $ClassMaster->query("DELETE FROM tblRequirementXref WHERE Class_Id = '" . $Class_Id . "'"); foreach ($Requirements as $Requirement) { $tblRequirementXref['Requirement_Id'] = $Requirement; $tblRequirementXref['Class_Id'] = $Class_Id; $ClassMaster->insert('tblRequirementXref', $tblRequirementXref); } $ClassMaster->query("DELETE FROM tblDates WHERE Class_Id = '" . $Class_Id . "'"); $tblDates['Class_Id'] = $Class_Id;