@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_080410 order by NOM";
$result=mysql_query($query);
$numrows = mysql_numrows($result);
echo "Inscriptions pour la journée d'équipe du 8 avril 2010 (".$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