title: I want the values from database on a combo box after matching some criteria
body: <p>Here is my html code:   </p>
  
  <pre><code>&lt;form action="ProductProcess.php" method="post"&gt;
      &lt;h1&gt; Update&lt;/h1&gt;
          &lt;label&gt;Product Type: &lt;/label&gt;
          &lt;select name="protype"&gt;
              &lt;option&gt; Hair Treatment &lt;/option&gt;
              &lt;option&gt; Hair Styling&lt;/option&gt; 
          &lt;/select&gt;  &lt;br&gt; &lt;br&gt;
  
          &lt;label&gt;Product Name&lt;/label&gt; 
          &lt;select name="proname"&gt;
              &lt;option&gt;
               //Here i want the values 
             &lt;/option&gt;
          &lt;/select&gt;&lt;br&gt; &lt;br&gt;
        &lt;/form&gt;
  </code></pre>
  
  <p>Here is the working php code:    </p>
  
  <pre><code>&lt;?php
    $protype=$_POST['protype'];
    //Connect
    $query=mysql_query("Select Product_Name from tbl_Products where Product_Type='".$protype."'");            
              if(!$numrows=mysql_num_rows($query)==0)
              {
                  while($row=mysql_fetch_assoc($query))
                  {
                      echo $row['Product_Name'];
                  }
              }
  ?&gt;
  </code></pre>
  
  <p>The php code displays the value on the other page. I want the results on the combo box of the above HTML page.</p>