mySQL all records from one table some records from other

[denniston]

I am setting up an attendance db.

I want to be able to go back and update the attendance after it is inserted.

I need to get all of the records from the table People.

I need to get the person_id's from roster where date = the selected date.

 

This only gives me the records where r.date = selected date.

$users = $db->get_results("SELECT p.*, r.date, r.person_id FROM People as p LEFT JOIN roster as r ON p.id = r.person_id WHERE r.date='$_POST[servicedate]'");

 

I need to have all of the records from People, as well as the person_id's from roster.

 

Thanks.

[JustLikeIcarus]

If im understanding correctly I think you need to use an OUTER JOIN.

[sasa]

change WHERE to AND

$users = $db->get_results("SELECT p.*, r.date, r.person_id FROM People as p LEFT JOIN roster as r ON p.id = r.person_id AND r.date='$_POST[servicedate]'");