You must enter the 5 digit ticket number."; //exit(); header("Location:newclass.php?id=$ID&error=1&course=$Course&title=$Title&days=$Days&starttime=$StartTime&endtime=$EndTime&dpt=$dept"); exit(); //} } //else { //if ($dept != "AMLA" OR $dept != "Chinese" OR $dept != "Italian") { //if (strlen($Class) != 5) { //print "

You must enter the 5 digit ticket number.

"; //exit(); // header("Location: newclass.php?id=$ID&error=$Class&course=$Course&title=$Title&days=$Days&starttime=$StartTime&endtime=$EndTime&dpt=$dept"); // exit(); //} //} include("../include/dbconfig.php"); $connection = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!"); mysql_select_db($db_name); $query = "select classid from SR_course where Semester='$semester' and Year='$syear' and classid like '$Class' limit 1"; echo "

Success!

"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)){ $check = $row[0]; } if ($check == $Class) { header("Location: newclass.php?id=$ID&error=2&course=$Course&title=$Title&days=$Days&starttime=$StartTime&endtime=$EndTime&dpt=$dept"); exit(); } $query = "insert into SR_course set Semester='$semester', Year='$syear', CourseID='$Course', CourseTitle='$Title', ClassID='$Class', InstructorID='$ID', Days='$Days', BeginTime='$StartTime', EndTime='$EndTime'"; //$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); //$result = mysql_query($query, $connection) or die ("Duplicate entry $Class, please enter a new ticket number."); $result = mysql_query($query, $connection) or die (header("Location:newclass.php?id=$ID&msg=$Class&course=$Course&title=$Title&days=$Days&starttime=$StartTime&endtime=$EndTime")); header("Location: newclass.php?semester=$Semester&id=$ID"); exit(); ?>
dired link