Hi guys,
Any idea as to how I can modify my JOIN statement to 'include' another table called chosen_module of which i'd like to select the field name "module_title" (from the chosen_module table) where student_id is also equal to $newvar?
$query = mysql_query("select * from student_table left join module_table on student_table.course_id = module_table.course_id where student_table.user_id='$newvar'");
Many thanks for your help with this
