1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
| if (isset($motclef))
//$dateencours=$motclef;
$clause = " where quand like '$motclef%'";
$orderby = " ORDER BY SUBSTR(quand,1,7),qui";
$sql = "SELECT * FROM ges_ae " . $clause . $orderby;
$resultat = mysql_query ($sql);
//echo $sql;
//
$result = mysql_query($sql) or die("erreur de base de données");
echo "Il y a ".mysql_num_rows($result)." élèves.";
//
echo '';
echo '<FONT SIZE="15">Accompagnement Educatif du jour:';
echo $dateencours;
echo $motclef;
while ($eleve = mysql_fetch_array ($resultat))
{
$inter= $eleve['qui'];
$nom = $eleve['Nom'];
$prenom = $eleve['Prenom'];
$date= $eleve['quand'];
$classe= $eleve['Codestructure'];
$quoi= $eleve['quoi'];
echo " <tr>";
echo "<td>$inter</td>";
echo "<td><B>$nom</td>";
echo "<td>$prenom</td>";
echo "<td>$classe</td>";
echo "<td>$quoi</td>";
echo "<td>$date</td>";
echo "<td>___</td>";
echo "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($liendb);
include("basae.inc.php");
?> |
Partager