title: Display information in dropdown list from database query PHP/HTML
body: <p>I'm having trouble with a bit of code I wrote, I can't seem to find any problems with it and its driving me crazy</p>
  
  <pre><code>    // create connection
  $conn=odbc_connect('SkyeGaccess1','','');
  
  if (!$conn)
    {exit("Connection Failed: " . $conn);}
  
    $sql = "SELECT Username FROM Customers";
  $rs = mysql_query($sql);
  
  echo "&lt;select name='Username'&gt;";
  while ($row = mysql_fetch_array($rs)) {
      echo "&lt;option value='" . $row['Username'] ."'&gt;" . $row['Username'] ."&lt;/option&gt;";
  }
  echo "&lt;/select&gt;";
  odbc_close($conn);
  ?&gt;
  </code></pre>
  
  <p>I've looked around everywhere and this seems to be exactly how I'm supposed to write this piece of code. Its not a problem with the database connection as I can put the information into a table just fine, but I just can't get it to show up on the dropdown list.</p>