ok Posted September 5, 2008 Share Posted September 5, 2008 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. Quote Link to comment Share on other sites More sharing options...
ok Posted September 5, 2008 Author Share Posted September 5, 2008 oh i think i get now the problem. problem solved. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.