@mysql_connect("mysql-1.univ-rennes1.fr","vis_databaseanum","9ex7mIckZ") or die("Echec de connexion au serveur");
mysql_query("use databaseanum");
$query="select * from inscriptions_journee_equipe_121109 order by NOM";
$result=mysql_query($query);
$numrows = mysql_numrows($result);
echo "Inscriptions pour la journée d'équipe du 12 novembre 2009 (".$numrows." inscrits)
\n";
echo "\n";
echo " NOM | Prénom | Équipe | Email | ";
echo "Buffet | ";
echo "
\n";
$type="pair";
for ($i=0;$i<$numrows;$i++)
{if ($type=="impair")
$type="pair";
else
$type="impair";
$nom = trim(mysql_result($result,$i,"NOM"));
$prenom = trim(mysql_result($result,$i,"PRENOM"));
$email = trim(mysql_result($result,$i,"EMAIL"));
$email = str_replace("@","[at]",$email);
$buffet = trim(mysql_result($result,$i,"BUFFET"));
$equipe = trim(mysql_result($result,$i,"Equipe"));
echo " \n";
echo " ".$nom." | \n";
echo " ".$prenom." | \n";
echo " ".$equipe." | \n";
echo " ".$email." | \n";
echo " ".$buffet." | \n";
echo "
\n";
}
echo "
\n";
echo "
\n";
// Date de mise a jour
/* $res = mysql_query("select DateModif from inscriptions_journee_equipe_130308 where ID=(SELECT MAX(ID) from inscriptions_journee_equipe_130308)"); */
/* if (mysql_numrows($res)>0) */
/* {$lastupdate = mysql_result($res,'DateModif',0); */
/* echo "Dernière modification de la base ".$lastupdate."
";} */
?>
Retour à la page d'accueil