Getting all records from one table and some from another

[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.

[fenway]

If you don't have matching records, then your where clause will always be false -- you might need to move it to the ON condition.