[SOLVED] why these codes display duplicate?

[ok]

I have these codes below

that will read unique user_name only from a table

but the problem is it duplicate the last name.

 

for example like this one,

anna anna
iridion iridion
solid solid
solid sollid 

 

and here is the codes.

<?php
include 'opendb.php';

$query = "SELECT user_name FROM user_join GROUP BY user_name";
$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());

$i=0;
while($row = mysql_fetch_array($result)) {
	$row2[$i] = $row['user_name'];
	echo "<br>". $row2[$i];
	$i++;
}

?>

 

thank you.

[ok]

oh i think i get now the problem.

 

problem solved.