syntax error cant find where

[deansaddigh]

I have a syntax error in my sql query, can anyone help me find it

 

$querycourselevels = "select school_course.school_id, school_course.course_id, course.name AS coursename,course.course_id, course.level, course.info, course.min_duration, course.weekly_interval, course.price, school.school_id, school.name AS school_name,
		  image.image_id, image.path, image.name AS image_name
              FROM image_school
              JOIN school
              ON image_school.school_id = school.school_id
              RIGHT JOIN image
              ON image_school.image_id = image.image_id
		  FROM school_course
		  JOIN course
		  ON school_course.course_id = course.course_id
		  JOIN school
		  ON school_course.school_id = school.school_id 
		  ORDER BY school_name";
		  $result = mysql_query($query, $conn)
			  or die ("error retrieving course levels");

 

error

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM school_course JOIN course ON school_course.course_id = course.course_id JOI' at line 1

[mikosiko]

....
             [b] FROM image_school[/b]
              JOIN school
              ON image_school.school_id = school.school_id
              RIGHT JOIN image
              ON image_school.image_id = image.image_id
          [b] FROM school_course[/b]
           JOIN course
           ON school_course.course_id = course.course_id
           JOIN school
           ON school_course.school_id = school.school_id 
           ORDER BY school_name";
           $result = mysql_query($query, $conn)
              or die ("error retrieving course levels");

 

 

 

2 times FROM ?.... I don't think so