';
echo 'Année 2003-2004';
echo "
\n";
while($data = mysql_fetch_array($req1))
{
echo "\n";
echo '
'.$data['nom_reel'].'';
echo "
\n";
}
echo "\n";
echo "
\n";
echo "
\n";
$sql1 = "SELECT nom_serveur,nom_reel FROM photos where promo='2002' ORDER BY nom_reel ASC";
// on envoie la requete
$req1 = mysql_query($sql1) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
echo '
';
echo 'Année 2002-2003';
echo "
\n";
while($data = mysql_fetch_array($req1))
{
echo "\n";
echo '
'.$data['nom_reel'].'';
echo "
\n";
}
echo "\n";
echo "
\n";
echo "
\n";
$sql1 = "SELECT nom_serveur,nom_reel FROM photos where promo='2001' ORDER BY nom_reel ASC";
$req1 = mysql_query($sql1) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
echo 'Année 2001-2002';
echo "
\n";
while($data = mysql_fetch_array($req1))
{
echo "\n";
echo '
'.$data['nom_reel'].'';
echo "
\n";
}
echo "\n";
echo '
';
mysql_close(); // on ferme la connexion
?>