There are two tables
"LESSON" TABLE
Attributes :
- id_lesson
-lesson_name
- semester

"LECTURES" TABLE
Attributes :
- id_lectures
- id_lesson
- id_lecturer
- hour
- day

How to display all atributes in lectures table where lessons in 2nd semester ?

Note : there's id_lesson in lectures table

Read the rules about showing effort on homework.

I have effort to solve this problem. But I don't know what I type in Google.

$query = mysql_query("SELECT * FROM LECTURES WHERE lessons.id_lessons. . . . . "). I don't what I type next !

You will not learn anything unless you research yourself. You may pass the course, but you will not have learned anything. Google "mysql table joins".

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.