I am currently developing a website that is used to display college
course information. I have everything running exactly as intended on my
server which utilizes Mysql 4.1. However, I recently uploaded it to the
college server which has Mysql 5.0 on it.
The query that I am having problems with is as follows:
SELECT
DISTINCT course.id,
course.courseid,
course.subject,
course.coursenumber,
course.section,
course.title,
course.credits,
course.type,
FORMAT(course.taken, 0),
FORMAT(course.total, 0),
course.extrainfo,
course.gradelevel,
course.semester,
DATE_FORMAT(FROM_UNIXTIME(courseinfo.starttime), "%h:%i %p"),
DATE_FORMAT(FROM_UNIXTIME(courseinfo.endtime), "%h:%i %p"),
courseinfo.days,
courseinfo.faculty,
courseinfo.room,
dept.title,
DATE_FORMAT(FROM_UNIXTIME(courseinfo.starttime), "%m/%e/%Y"),
DATE_FORMAT(FROM_UNIXTIME(courseinfo.endtime), "%m/%e/%Y"),
DATE_FORMAT(FROM_UNIXTIME(semester.startdate), "%m/%e/%Y"),
DATE_FORMAT(FROM_UNIXTIME(semester.enddate), "%m/%e/%Y")
FROM
course
INNER JOIN courseinfo
INNER JOIN dept
INNER JOIN semester
...
Bookmarks