title: Dropdown from database without duplicate data
body: <p>I'm trying to create a dropdown list of my product type from the database, I'm using this code from <a href="https://stackoverflow.com/questions/8022353/how-to-populate-html-dropdown-list-with-values-from-database">How to populate HTML dropdown list with values from database</a>.</p>
  
  <pre><code>&lt;select name="product_type"&gt;
  &lt;?php 
  include('include/conn.php');
  $sql = mysql_query("SELECT product_type FROM produk2");
  while ($row = mysql_fetch_array($sql)){
  echo "&lt;option value=\"product_type1\"&gt;" . $row['product_type'] . "&lt;/option&gt;";
  }
  
  ?&gt;
  &lt;/select&gt;
  </code></pre>
  
  <p>I'm going to add this in my search engine, but the dropdown from that code making it read all data from product_type. Is it possible to create the dropdown without the same product_type twice?</p>