nickelus Posted July 15, 2009 Share Posted July 15, 2009 here's an interesting one, i have a two tables client and schedule which have a common key of "client_id", and i am composing a "schedule list" page. i can get the client_id & dates to display from the schedule table using fetch_array, however i need the matching addresses (which are stored in the client table) to be displayed in each row as well. i have tried this JOIN statement /* "SELECT * FROM pu_sched AS pu JOIN client_pu_site AS st ON st.client_id=pu.client_id WHERE `pu_date` = ''"*/ but end up with only one of the client ids in my resulting list. can i make a separate array of the client table and match these in php or is my join statement wrong somehow Quote Link to comment Share on other sites More sharing options...
rhodesa Posted July 15, 2009 Share Posted July 15, 2009 You need a LEFT JOIN SELECT * FROM pu_sched AS pu LEFT JOIN client_pu_site AS st ON st.client_id=pu.client_id WHERE `pu_date` = '' Quote Link to comment Share on other sites More sharing options...
nickelus Posted July 15, 2009 Author Share Posted July 15, 2009 thanks so much i can over look one little thing like that and be banging my head against the desk for hours. 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.