@mysql_connect("mysql-1.univ-rennes1.fr","vis_databaseanum","9ex7mIckZ") or die("Echec de connexion au serveur");
mysql_query("use databaseanum");
$query="select * from EDP_JE01 order by nomBDO";
$result=mysql_query($query);
$numrows = mysql_numrows($result);
echo "Inscriptions pour la 1ère Journée de l'équipe EDP, 20 octobre 2011 (".$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";
$nomAFF = trim(mysql_result($result,$i,"nomBDO"));
$prenomAFF = trim(mysql_result($result,$i,"prenomBDO"));
$emailAFF = trim(mysql_result($result,$i,"emailBDO"));
$emailAFF = str_replace("@","[at]",$emailAFF);
$buffetAFF = trim(mysql_result($result,$i,"buffetBDO"));
$equipeAFF = trim(mysql_result($result,$i,"equipeBDO"));
echo " \n";
echo " ".$nomAFF." | \n";
echo " ".$prenomAFF." | \n";
echo " ".$equipeAFF." | \n";
echo " ".$emailAFF." | \n";
echo " ".$buffetAFF." | \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