title: populate dropdown using mysqli
body: <p>I am having a problem with populating the dropdown list. The page is not showing the dropdown. It doesn't throw any exception either. I appreciate any help.</p>
  
  <pre><code> $mysqli = new mysqli($db_host, $db_username, $db_password, $db_database);
    if (mysqli_connect_error()) {
      die('Connect Error (' . mysqli_connect_errno() . ') '
              . mysqli_connect_error());
    } 
    &lt;?php 
       $SQL = "SELECT c_id, c_name FROM table1"; 
       $result = $mysqli-&gt;query($SQL);
     ?&gt; 
   &lt;select id="country" name="country"&gt;    
      &lt;option value=''&gt;&lt;/option&gt;    
    &lt;?php 
      while ($row = $result-&gt;fetch_object()) 
      {       
      echo "&lt;option value='{$row['c_id']}'&gt;{$row['c_name']}&lt;/option&gt;\n";
     }   
  ?&gt;  
  &lt;/select&gt;
  </code></pre>