title: PHP dropdown list with data from a MySQL database
body: <p>i have been try for PHP dropdown list with data from a MySQL database.</p>
  
  <p>I have attached my code below, am not getting the dropdownlist .Can anyone help </p>
  
  <pre><code>&lt;?php
  $conn   =   mysql_connect('localhost','root','');
  mysql_select_db('qsearch',$conn);
  $query = "select Category from information";
  $result = mysqli_query($query);
  echo '&lt;select id="info" name="info"&gt;';
  echo '&lt;option value=""&gt;-select-&lt;/option&gt;';
  while ($row = mysqli_fetch_assoc($result)){
  ?&gt;
      &lt;option value="&lt;?php echo $row['Category']; ?&gt;"&gt;&lt;?php echo $row['Category'];         ?&gt;     &lt;/option&gt;
  &lt;?php    
  }
  echo "&lt;/select&gt;";
  ?&gt;
  </code></pre>