How to get unique values ​​from MySQL DB?

Question

MySQL

There is such a table in the database:

And a table that displays the result: refsumma

=> To output

Answer 1

Based on the "tips" something like this:

$result_table = "SELECT DISTINCT `games`, `refsumma`, `nickname`,`id`
 FROM `dlepisode1` 
WHERE `approved` IS NULL 
ORDER BY `refsumma` 
DESC" ;

But there is a big suspicion that you underdescribed the task, so then think about what you really wanted there.