|
Top 5 membres les + populaires
|
|
$requete = mysql_query("SELECT * FROM friends_top ORDER BY top_friends DESC LIMIT 0,5");
$total_friends = mysql_numrows($requete);
$i = 0;
while ($i < $total_friends)
{
// la je fait commencer les chiffres à 1 (pour le top 5)
$a=1;
$compteur = $i+$a;
$pseudo_contact = mysql_result($requete,$i,"pseudo_contact");
$category = mysql_result($requete,$i,"category");
$top_friends = mysql_result($requete,$i,"top_friends");
$i++;
$pseudo_contact2 = strtr($pseudo_contact, 'ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðòóôõöùúûüýÿAZERTYUIOPQSDFGHJKLMWXCVBN', 'AAAAAACEEEEIIIIOOOOOUUUUYaaaaaaceeeeiiiioooooouuuuyyazertyuiopqsdfghjklmwxcvbn');
?>
echo "$compteur $pseudo_contact " ;?> echo " tribu $category
Nombre de vote : $top_friends Voir sa fiche | "; } ?> |
@mysql_close($db); ?> |
|
Les derniers membres inscrits
|
|
$requete = mysql_query("SELECT * FROM membres ORDER BY clef DESC LIMIT 0,6");
$total = mysql_numrows($requete);
$i = 0;
while ($i < $total)
{
$pseudo_membre = mysql_result($requete,$i,"pseudo");
$age = mysql_result($requete,$i,"age");
$region = mysql_result($requete,$i,"region");
$pays = mysql_result($requete,$i,"pays");
$photo = mysql_result($requete,$i,"photo");
$category = mysql_result($requete,$i,"category");
$i++;
?>
// on enleve les accents pour l'addresse url
$pseudo2 = strtr($pseudo_membre, 'ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðòóôõöùúûüýÿAZERTYUIOPQSDFGHJKLMWXCVBN', 'AAAAAACEEEEIIIIOOOOOUUUUYaaaaaaceeeeiiiioooooouuuuyyazertyuiopqsdfghjklmwxcvbn');
// FIN des accents ?>
echo "$pseudo_membre de $age " ;?> echo " $region, $pays $category Plus d'infos | "; } ?>
|
|
|