Hello,
Zitat:
It's an easy mistake that I have left as it is...from me. You have to find it out yourself. Write the error message here.
The error was in the connection settings
I almost visit GitHub website and i didn't know it is a repository
thank you for all the information that will help me in the future
There is only one last question
You said
- Never use
DB tables. Better use Querys.
That's means i link all the tables together with JOIN(inner,Left or Right) the question is If, for example, we add another table to the database let it be 'Group' -->the relation between Student and Group is one to many(Each student has one group, and each group has more than one student)
We write two queries the first to show the students and their grades And the other to show the students and their group or only one
query ?
because if we write one
query the result it will be wrong
Code:
SELECT E.ID, E.NOM, E.PRENOM, GroupName,LE.NOMLECON, LE.NOTE FROM ETUDIANT E
JOIN ETUDLECON LO ON E.ID = LO.ID
JOIN LECON LE ON LO.LECONID = LE.LECONID
JOIN Group G ON G.GroupID = E.GroupID