Sql not bringing any results back when it should

[deansaddigh]

Is my where clause syntax correct please?

 

$query = "SELECT course.course_id, course.name AS course_name, course.level, course.price,  course.duration, course.info, course_type.type, school.school_id AS school_id, school.name AS school_name, school.street, school.town, school.city, school.county, school.region, school.postcode, school.country, school.school_facts, school.general_info, school.school_facilities
            FROM school_course
          
	    JOIN course
            ON school_course.course_id = course.course_id
          
	    JOIN school
            ON school_course.school_id = school.school_id

		JOIN course_coursetype
		ON course.course_id = course_coursetype.course_id

		JOIN course_type
            ON course_coursetype.course_typeid = course_type.course_typeid

		WHERE region = '$region' AND course_type.type = $coursetype";

[fenway]

Does it work or not?