Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getCoursesDetails($course,$date)
- {
- $query = "SELECT course.courseID, course.courseName, course_room.roomID,course_room.day_date, course_room.start_time, course_room.end_time, prof.firstName, prof.lastName, prof.profID FROM course, course_room, prof
- WHERE course_room.courseID = course.courseID AND course.courseName = $course AND course_room.day_date = $date AND prof.profID = course.profID";
- $result = mysql_query($query);
- $arr = array();
- while($record = mysql_fetch_assoc($result))
- {
- $arr[] = array ('courseID' => $record['courseID'],
- 'courseName' => $record['courseName'],
- 'roomID' => $record['roomID'],
- 'date' => $record['day_date'],
- 'starting' => $record ['start_time'],
- 'ending' => $record['end_time'],
- 'firstName' => $record['firstName'],
- 'lastName' => $record['lastName']);
- }
- echo json_encode($arr);
- }
Add Comment
Please, Sign In to add comment