C_Kirby

<?

$sql = 'SELECT pseudo FROM forum_users';

	$req = mysql_query($sql);

	while ($data = mysql_fetch_array($req)) {

	$pseudopost = $data['pseudo'];

	$sql2 = 'SELECT * FROM forum_posts WHERE auteur = "'.$pseudopost.'"';

	$req2 = mysql_query($sql2);

	$posts = mysql_num_rows($req2);

	$posteur[] = array (

	'$pseudopost', '$posts'

	);

    }

	$pseudo_posteur = max($posteur);

?>

<?php

echo '<select name="avatar">';

$sql2 = 'SELECT * FROM forum_avatars';

$req2 = mysql_query($sql2) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error);

while ($data2 = mysql_fetch_array($req2)) {

$name_avatar = $data2['nom'];

$image_avatar = $data2['image'];



echo '<option value="'.$image_avatar.'">'.$name_avatar.'</option>';

}

echo '</select><br><img src="rangs/'.$avatar.'.gif"><br>'.$name_avatar_profil; // On affiche l'image ($name_avatar_profil correspont a l'ancien avatar et $avatar a l'ancienne image)

?>