I have four tables in my DB - one, called kursplan, 2nd table is kursplan_kurse,3rd table is kursplan_kursraum 4th table is kursplan_trainer.
The 1st table Structure: id,club_id,Tag,Kurse_namen,from,to,Kursleiter,kursraum
here club_id means my user id in my user table
id | club_id | Tag |Kurse_namen | Kursleiter| kursraum
____________________________________________________________________________________________
1 | 35 | Monday |2 |2 | 4
2 | 35 | tue |3 |3 | 3
3 | 35 | wen |3 |3 | 3
4 | 12 | thu |1 |2 | 4
The 2nd table Structure:table name[kursplan_kurse]
id | club_id | Kurse_namen
______________________________________
1 | 35 | Kurse1
2 | 35 | Kurse2
3 | 35 | Kurse3
4 | 35 | Kurse4
The 3rd table Structure:table name[kursplan_kursraum]
id | club_id | kursraum
______________________________________
1 | 35 | kursraum1
2 | 35 | kursraum2
3 | 35 | kursraum3
4 | 35 | kursraum4
The 4thtable Structure:table name[kursplan_trainer]
id | club_id | Kursleiter
______________________________________
1 | 35 | Kursleiter1
2 | 35 | Kursleiter2
3 | 35 | Kursleiter3
4 | 35 | Kursleiter4
My select query is
$query = "SELECT * FROM `kursplan` WHERE `club_id` = '35' AND `Tag` = 'Monday' ";
I am geting the result in this format
Kurse_namen | kursraum |Kursleiter |
=====================================
2 | 4 |2 |
Now, what I want to achieve is to setup a JOIN query for get values from all 3 tables that are 2nd,3rd,4th tables
I need the result in this format I MEAN Instead of numbers i want names
Kurse_namen | kursraum | Kursleiter
______________________________________________
Kurse2 | kursraum4 | Kursleiter2
Please help me.