Plus grand posteur

<?

$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);

?>

<?

$sql   = "Select * FROM forum_truc ORDER BY nb_post DESC LIMIT 0,1";

$req   = mysql_query($sql) or die;

$data  = mysql_fetch_array($req);



$plusgrandposteur = $data['pseudo'];

?>

<?php

$sql = 'SELECT pseudo FROM forum_users'; 

$req = mysql_query($sql);

$i = 0;

$posteur = array();



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); 

mysql_free_result($req2);



$posteur[$i][0] = $pseudopost;

$posteur[$i][1] = $posts;



$i = $i + 1;

}

mysql_free_result($req);



// et la tu as ton tableau $posteur qui contient le nom des membres (indice 0) ainsi que leur nombre de post (indice 1)

// Te reste plus qu'a parcourir ce tableau a la recherche du plus grand posteur

?>