JOIN problem

[Anon]

Tables: Coursework_table, Result_table

Common Fields: coursework_id

I have created a table which displays data as requested by this join. Problem is that no data is displayed if there is no record in the coursework_id field within the result_table. I would like results to still be displayed 'even' if there is no record inside the coursework_id field within the result_table.

Any suggestions on how i can tweak this join to suit my needs?

Thanks.

$result = mysql_query("select * from coursework_table, result_table where coursework_table.user_id='$mycookie' AND coursework_table.coursework_id = result_table.coursework_id ORDER by submission_time");

[[deleted]]

Read the MYSQL manual about the LEFT JOIN, that will do the JOIN even if there is no match.

[Anon]

thanks Vince,

problem solved.