title: While loop inside SELECT
body: <p>I am new to php and html, so I need some help with a problem: I am trying to make a form where you can select from a dropbox, but thae data from the dropbox should be retrieved from a sql database.
  If I save the code bellow as php, the dropbox is created and retrieves the data from sql, but then the submit button (together with everything else I put after the while loop) disappeares. If I save it as a html file, the form and submit button works, but it doesn't retrieve any data from sql database.</p>
  
  <p>Thanks</p>
  
  <pre><code>&lt;form action="Techniques.php" method="post"&gt;
          &lt;p&gt;Which Disease?
          &lt;select name="disease" &gt;
              &lt;option value="" &gt;--Select--&lt;/option&gt;
          &lt;?php
            require_once("dbconnect.php");
  
            $sql = "SELECT * FROM diseases";
            $result = mysql_query($sql)or die (mysql_error());
                  while($row = mysql_fetch_array($result) or die (mysql_error()))
                  {
          ?&gt;
                   &lt;option value ="&lt;?php echo($row['Disease']);?&gt;"&gt;&lt;?php echo($row['Disease']);?&gt;&lt;/option&gt;
          &lt;?php
                  }
          ?&gt;        
  
          &lt;/select&gt;
          &lt;/p&gt;
          &lt;input type="submit" value="Copmlete"/&gt;
      &lt;/form&gt;
  </code></pre>