1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| ?php
include("includes/mon fichier.inc");
$connection= mysql_connect($host,$user,$password);
$db = mysql_select_db($database,$connection);
$sql="SELECT * FROM blogs ORDER BY nb_clics DESC LIMIT 0, 5";
$retour=mysql_query($sql);
$i=0;
while($donnees=mysql_fetch_array(mysql_query($sql)))
{
$i++;
$pseudo=$donnees['username'];
$sql = "SELECT * FROM utilisateurs WHERE pseudo=\"{$pseudo}\"";
$retour = mysql_query($sql);
$donnees = mysql_fetch_array($retour);
$avatar = $donnees['avatar'];
echo'<li><div align="center">';
echo '#',$i,' ',$pseudo ?><?php echo"<img src='membres/avatars/{$avatar}' />"; echo'</div>
</li>';
}
?> |
Partager