profID, fName, lName FROM professor WHERE fName OR lName LIKE $query; // search for professor ajax livesearchcourse WHERE courseID OR name OR primaryCode or secondaryCode LIKE $query; // search for course ajax livesearchcode
SELECT name FROM department WHERE na