title: Populate dropbox in html with values of mysqli database using php
body: <p>The database has a list of storeids and I want that to be populated in my dropdown list.The following code seems right but only yes is getting displayed in the list.</p>
  
  <pre><code> Store id:
  &lt;select&gt;
      &lt;option value="yes"&gt;yes&lt;/option&gt;
  &lt;?php include 'database.php'; ?&gt;
  &lt;?php
      $query=mysqli_query($connect,"SELECT storeid from store");
      while($list=mysqli_fetch_array($query))
      {
      $storeid=$list['storeid'];
      echo '&lt;option value="' . $storeid . '"&gt;' . $storeid . '&lt;/option&gt;';
       }    
  ?&gt;
  &lt;/select&gt;&lt;br&gt;
  </code></pre>