Member Avatar for andika.kurniawan.121

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

Edited by andika.kurniawan.121
  • 3 Contributors
  • 4 Replies
  • 141 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by TonyG_cyprus

Recommended Answers

All 4 Replies

Member Avatar for Ezzaral

Read the rules about showing effort on homework.

Member Avatar for andika.kurniawan.121

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

Member Avatar for andika.kurniawan.121

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

Edited by andika.kurniawan.121
Member Avatar for TonyG_cyprus

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.