Join

[wemustdesign]

 

I am joining 2 tables. This query word fine:

 

$query = "SELECT site_users.firstName, site_users.telephone, students.places, students.paymentType, students.paymentStatus

"."FROM site_users LEFT JOIN students".

"ON site_users.username = students.user";

 

I now want to only show results that match up to the field $courseID. I tried this but just got an error:

 

$query = "SELECT site_users.firstName, site_users.telephone, students.places, students.paymentType, students.paymentStatus

"."FROM site_users LEFT JOIN students WHERE course = $courseID".

"ON site_users.username = students.user";

[Mchl]

WHERE clause has to be placed after JOIN ... ON ... clause

[wemustdesign]

Thanks for the reply, that worked:

 

$query = "SELECT site_users.firstName, site_users.telephone, students.places, students.paymentType, students.paymentStatus "."FROM site_users LEFT JOIN students "."ON site_users.username = students.user WHERE students.course = '$courseID'";