title: Create and fill combo box with mysql data with php
body: <p>I have done google searches and found several answers but I cannot get this to work. I am trying to read a field from ym mysql database and create and populate a combo box containing those values. The database connection works but all I get is a list of the values and no combo box. I am posting my code, along with the results.</p>
  
  <pre><code>&lt;?php
  $cn=mysql_connect("localhost","username","password") or die(mysql_error());
  mysql_select_db("db_name",$cn) or die(mysql_error());
  $sql = "SELECT LoadNumber FROM tblLoads";
  $result = mysql_query($sql);
  ?&gt;
  &lt;select name="loads" size=1&gt;
  &lt;?
  while($ri = mysql_fetch_array($result))
  {
  echo "&lt;option value=" .$ri['LoadNumber'] . "&gt;" . $ri['LoadNumber'] . "&lt;/option&gt;";
  }
  echo "&lt;/select&gt; "
  ?&gt;
  </code></pre>
  
  <p>Here is my output:</p>
  
  <pre><code>1637825
  1637933
  1638102
  1638109
  1638574
  1638683
  &gt;
  </code></pre>
  
  <p>Please, this is driving me crazy, i don't see what I am doing wrong. it does not create the combo box.</p>