if in query

[techker]

hey guys i have this query up to know that works like i need..but i would like to add an if clause to trigger a notification if the student has more then 2 detentions with the same teacher??

 

 

k i got this going shows me the count and the student

 

///search student teacher repeat fr

$fileSQL="SELECT COUNT(*), `Etudiant`, `Prof` FROM Rapport_R\n"
    . "GROUP BY `Etudiant`, `Prof`\n"
    . "HAVING COUNT(*)>1";

$fileLIST=mysql_query($fileSQL);

 

///french\\

<? while ($row = mysql_fetch_array($fileLIST)) { ?>
     <? echo $row['Etudiant'] ?> a <? echo $row['COUNT(*)'] ?> retenues Avec le Professeur <? echo $row['Prof'] ?> </br>
  <? } ?>

the DB has

 

ID-Etudiant-Prof-Day-Notes

 

 

[asmith]

$fileSQL="SELECT COUNT(*), `Etudiant`, `Prof`, IF(COUNT(Etudiant) > 2, 'yes', 'no') AS moreThanTwo FROM Rapport_R\n"
    . "GROUP BY `Etudiant`, `Prof`\n"
    . "HAVING COUNT(*)>1";

[techker]

hmm cool.what would the echo look like?

 

echo ['COUNT(Etudiant')

[asmith]

if ($row['moreThanTwo'] == 'yes')

    // Do stuff

[techker]

ya but it has to be student with teacher more than two no?

 

cause the teacher can be repeated with other students or even that student can have a detention with other teachers..

[techker]

what about something like this

 

if($fileLIST)
{
	$row = mysql_fetch_array($fileLIST);
	$ret["Etudiant"] 		==	>2  $row["Prof"];

}

echo $row['Etudiant'] ;