tvdhoff Posted August 7, 2006 Share Posted August 7, 2006 Hi all,This calendar page uses two database tables: 'calendar' which holds the appointment info and which is linked using column 'location_id' with table 'locations' which holds the location details.On the overview page I retrieve appointments using this query which works fine:[code]$listAppointmentsQuery="SELECT id,name,DATE_FORMAT(date,'%d-%m-%Y') AS date,time,location_name FROM calendar INNER JOIN locations USING (location_id) ORDER BY date DESC";[/code]However, when a user deletes a location, the appointments that have that location are not displayed using this query. Is there a way to modify the query so that those entries are displayed (with an empty location) as well?I'd rather not have to run through all appointments resetting their location_id when a location is deleted....thanks!Tim Quote Link to comment Share on other sites More sharing options...
king arthur Posted August 7, 2006 Share Posted August 7, 2006 Try a left join. Quote Link to comment Share on other sites More sharing options...
tvdhoff Posted August 7, 2006 Author Share Posted August 7, 2006 thanks, that helped. Quote Link to comment 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.