title: Select one row without duplicate entries
body: <p>In mysql table <code>info</code> i have :</p>
  
  <blockquote>
    <p>Id , Name , City , date , status</p>
  </blockquote>
  
  <p>I want to select all names from "info"
  Making the query</p>
  
  <pre><code>$query = mysql_query("SELECT name FROM info WHERE status = 1 ORDER BY id") 
           or die(mysql_error());
  
  while ($raw = mysql_fetch_array($query)) 
  {
    $name = $raw["name"];
    echo ''.$name.'&lt;br&gt;';
  }
  </code></pre>
  
  <p>Well, the result is that it returns all the entries.
  I want to echo all the entries without duplicates.</p>
  
  <p>Saying: under raw "name" we have inserted the name "John" 10 times.<br>
  I want to echo only one time.
  Is this possible?</p>