[SOLVED] seperate fetch arrays combine or join?

[nickelus]

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

[rhodesa]

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` = ''

[nickelus]

thanks so much i can over look one little thing like that and be banging my head against the desk for hours.