How to combine sql SELECT queries and SELECT DISTINCTROW?

There are N-th number of columns in a table where one of the columns I need to display using SELECT DISTINCTROW and others simply SELECT using a table with the results displayed using a while loop help to think how this matter can be combined?
June 3rd 19 at 19:39
2 answers
June 3rd 19 at 19:41
Solution
Made artful displays what I wanted
$result_table = "SELECT DISTINCT `games` FROM `dlepisode1` WHERE `approved` IS NULL ORDER BY `refsumma` DESC" or die(mysql_error());
 $rs = mysql_query($result_table, $bd_connect);
 $result_table_1 = "SELECT `refsumma`, `nickname`, `payeer` FROM `dlepisode1` WHERE `approved` IS NULL ORDER BY `refsumma` DESC" or die(mysql_error());
 $rs_1 = mysql_query($result_table_1, $bd_connect);
 while($myrow = mysql_fetch_array($rs) AND $myrow_1 = mysql_fetch_array($rs_1))
 {echo "".$myrow['games']."
 ".$myrow_1['nickname']."".$myrow_1['refsumma']."".$myrow_1['payeer']."";}?>
June 3rd 19 at 19:43
And how do you imagine such a conclusion? DISTINCTROW means that all result rows must be unique.

Find more questions by tags MySQL