Open eClass

1054: Unknown column 'course.id' in 'field list'

SELECT course.id cid, course.code code, course.public_code,
course.title title, course.prof_names profs, course_user.statut statut
FROM course JOIN course_user ON course.id = course_user.course_id
WHERE course_user.user_id = 1
ORDER BY statut, course.title, course.prof_names

1054: Unknown column 'course.id' in 'field list'

SELECT course.id course_id,
course.code code,
course.public_code,
course.title title,
course.prof_names professor,
course.lang,
course_user.statut statut,
user.perso,
user.announce_flag,
user.doc_flag,
user.forum_flag
FROM course, course_user, user
WHERE course.id = course_user.course_id AND
course_user.user_id = 1 AND
user.user_id = 1
ORDER BY course.title, course.prof_names

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/modules/perso/lessons.php on line 90