For each unique user in mysql table echo

<?php
 mysql_connect(....);
 mysql_select_db(...); 
 $query = "select `name` from yourtable group by `name` ";
 $rows = mysql_query($query);
 while ($row = mysql_fetch_assoc($rows))
 {
   print "{$row['name']}<br>";
 } 
?>

Select allOpen in new window