title: my 'Select DISTINCT' is not working properly
body: <p>I tried to populate my drop down menu with some values from the database.
  After I use 'Select DISTINCT'it does not retrieve all the data in my data base.</p>
  
  <p>Here is my php code</p>
  
  <pre><code>&lt;?
     $sqlretrive = mysql_query("Select DISTINCT type from 
               tb_shuffle_table where status = 1 and user_id = $user_id");
     $rows = mysql_fetch_array($sqlretrive)
  ?&gt;
  </code></pre>
  
  <p>and here is my html code</p>
  
  <pre><code>&lt;select name="type" id="type" class="form-control" required &gt;
        &lt;option value=""&gt;Please Select Question Type&lt;/option&gt;
        &lt;? while ($row = mysql_fetch_array($sqlretrive)){ ?&gt;
        &lt;option value="&lt;?=$row['type']?&gt;"&gt;
          &lt;?=$row['type']?&gt;
          &lt;/option&gt;
        &lt;? }?&gt;
      &lt;/select&gt;&lt;/td&gt;
  </code></pre>
  
  <p>{this is my database table}<a href="http://i61.tinypic.com/1433xxi.jpg" rel="nofollow">1</a></p>