deansaddigh Posted February 22, 2010 Share Posted February 22, 2010 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"; Quote Link to comment https://forums.phpfreaks.com/topic/192971-sql-not-bringing-any-results-back-when-it-should/ Share on other sites More sharing options...
fenway Posted February 24, 2010 Share Posted February 24, 2010 Does it work or not? Quote Link to comment https://forums.phpfreaks.com/topic/192971-sql-not-bringing-any-results-back-when-it-should/#findComment-1017477 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.