hey guys this is the structure of the Db:
Ex_ID int(11) NOT NULL auto_increment,
N_Etudiant varchar(25) NOT NULL,
Professeur varchar(50) NOT NULL,
Foyer varchar(50) NOT NULL,
Motif varchar(50) NOT NULL,
Date date NOT NULL,
Notes text NOT NULL,
Autre varchar(150) NOT NULL,
so basically N_Etudiant is a student name…
so when we insert it looks like
N_Etudiant Mike
Professeur mrpopins
Foyer 301
Motif fight
Date 2011/01/01
Notes none
Autre 0
so the query i need is to flag if (N_Etudiant) has the same (Professeur) more the 2 times
cause we need to know if the student (N_Etudiant) has been expelled from class by the same teacher (Professeur) more then 2 times…
is this clear?lol