denniston Posted December 1, 2009 Share Posted December 1, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/183600-getting-all-records-from-one-table-and-some-from-another/ Share on other sites More sharing options...
fenway Posted December 4, 2009 Share Posted December 4, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/183600-getting-all-records-from-one-table-and-some-from-another/#findComment-971231 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.