';
$sql='select Numéro, Ecole, Type from ecole where Type=2 order by Ecole';
$result=mysql_data_query($db, $sql);
while ($row=mysql_fetch_array($result))
{
echo "
$row[Ecole]
";
}
echo '
';
echo '
';
echo '
Liste des spécialites
';
$sql='select distinct Formation from ecole where Type=1 order by Formation';
$result=mysql_data_query($db, $sql);
while ($row=mysql_fetch_array($result))
{
echo "