Dear all master,
I made application for report an assessment that have 3 tables, mapel(course subject), nilai(course value) and siswa(student).
I want to show all course subject and filter by student ID, and if there are no course subject in course value, it always show all course subject
but with 0 course value.
I try to use JOIN TABLE, but if i add WHERE clause, it not work like i want.
May be you can view my PHP Code and MySQL Code.
PHP FILE :http://pastebin.com/aHjes1tX
SQL FILE : http://pastebin.com/ZGtB0p1E
Please help me,
Thanks before, master