Mysql query with PHP brings duplicate results

Question

I’m trying to create a code in php to build a ranking, I managed to make the data appear, the problem is that is duplicating the results.

$rank = mysql_query("SELECT * FROM user_quizzes ORDER BY pass_score_point DESC") or die(mysql_error());

    $i = 0;
    while($row = mysql_fetch_assoc($rank)){
        $i++;

$rank2 = mysql_query("SELECT * FROM users WHERE not UserName='admin' ORDER BY UserName DESC") or die(mysql_error());
    $i2 = 0;
    while($row2 = mysql_fetch_assoc($rank2)){
        $i2++;

$result = mysql_query('SELECT SUM(pass_score_point) AS pass_score_point FROM user_quizzes' ); 
$row3 = mysql_fetch_assoc($result); 
$sum = $row3['pass_score_point'];       


?>


        <div class="topo">
         <?php echo $row2['UserName']; ?> com <?php echo $row3['pass_score_point']; ?> pontos de acertos! 
        </div>

Answer 1

In your consultation: A [SELECT SUM(pass_score_point) AS pass_score_point FROM user_quizzes] you have to group by some column with GROUP BY Ex. SELECT username, SUM(pass_score_point) AS pass_score_point FROM user_quizzes Group By username

I don’t know why field you have to group but aggregation functions like SUM() have to have group by.

Below is the syntax of GROUP By:

SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name Operator value GROUP BY column_name;

Answer 2

try to do this in your query

$rank2 = mysql_query("SELECT * FROM users WHERE userID='".$row['user_id']."' LIMIT 0,1") or die(mysql_error());

and see if the duplicate problem has been solved