help with my where clause

[deansaddigh]

im getting an

Unable to perform query: Unknown column 'scotland' in 'where clause'

 

Can someone help me.

 

	
	$query = "SELECT course.course_id, course.name AS course_name, course.level, course.price, course.duration, course.info, 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
		WHERE school.region Like $region AND course_type.type LIKE $coursetype ";

[rckehoe]

I am not sure if this will help or not, but you may want to try something like this:

WHERE school.region Like \"$region\" AND course_type.type LIKE \"$coursetype\" ";

[deansaddigh]

Cheers for the help, that didnt work unfortunatly,

i have changed the where clause to = instead of like.

Can anyone help been stumped as to why i get this error

 

Unable to perform query: Unknown column 'scotland' in 'where clause'

 

sql query

 

$query = "SELECT course.course_id, course.name AS course_name, course.level, course.price, course.duration, course.info, 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
		WHERE school.region = $region AND course_type.type = $coursetype ";
           
            //Use this query below         
            $result = mysql_query($query, $conn)
               or die ("Unable to perform query: " . mysql_error());   

[trq]

String values need to be surrounded by quotes within sql. I believe the last poster also pointed out this same issue.