'0' AND userId.moisNaissance='".$moisEnCours."' AND userId.valid='Y' AND userId.deserteur='N' ORDER BY userId.dateCreation"; //echo $sql."

---

"; $sql = mysql_query($sql); while ($mr = mysql_fetch_array($sql)) { if ($bg=="#F4F2FE") $bg = "#FFFFFF"; else $bg = "#F4F2FE"; echo ""; $userId = $mr['userId']; $pseudo = $mr['pseudo']; $nbrPost = $mr['nbrPost']; $dateCreation = $mr['dateCreation']; $morceau = explode ("-", (substr($dateCreation,0,10))); $dateCreation=$morceau["2"]."/".$morceau["1"]."/".$morceau["0"]; $avatar = $mr['avatar']; $ville = $mr['ville']; $jN = $mr['jourNaissance']; $mN = $mr['moisNaissance']; $aN = $mr['anneeNaissance']; if ($pseudo=="Staf") { $monAnniLib = "-"; } else { if ($jN<>0 AND $mN<>0 AND $aN<>0) { $timestamp = mktime(0,0,0,$mN,$jN,date("Y")); $monAnni = (floor(($timestamp - (time())) / 86400)+1); $monAnniLib = "Dans ".$monAnni." jours"; if ($monAnni==0) {$monAnniLib = " JOYEUX Anniversaire ! ";} else if ($monAnni<0) { $timestamp = mktime(0,0,0,$mN,$jN,(date("Y")+1)); $monAnniLib = "Dans ".(floor(($timestamp - (time())) / 86400)+1)." jours"; } } else { $monAnniLib = "?"; } } //echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; } ?>

	Pseudo	Ville	Inscrit le	Anniversaire
		".$pseudo."	".$ville."	".$nbrPost."	".$dateCreation."	".$monAnniLib."