title: Php inside html to create drop box list
body: <p>i want to do a drop box list which can show a list of value took from the database.
  i have code these but i dont know why it wont show the drop box list.
  I have save the file as .php</p>
  
  <pre><code>&lt;html&gt;
  &lt;head&gt;
  &lt;style&gt;
  body{
      background-color: #666699;
  }
  &lt;/style&gt;
  &lt;/head&gt;
  &lt;body&gt;
  
      &lt;h1 style="text-align:center;"&gt;Society/club System&lt;/h1&gt;
      &lt;h2 style="text-align:center;"&gt;Student&lt;/h2&gt;
      &lt;div class="box"&gt;
          &lt;ul id="button"&gt;
              &lt;?php 
  
  
                  $db_handle = mysql_connect("localhost","root","");
                  $db_found = mysql_select_db("sdp", $db_handle);
  
                  $sql='SELECT title FROM club order by title';
                  $query= mysql_query($sql);
                  echo '&lt;select name="club name"&gt;';
                  while ($row=mysql_fetch_array($query)) {
                      echo'&lt;option value="'.$row['title'].'"&gt;'.$row['title'].'&lt;/option&gt;';
                  }
                  echo'&lt;/select&gt;';
                  ?&gt;
          &lt;/ul&gt;
      &lt;/div&gt;
      &lt;div style="text-align:right;"&gt;&lt;li&gt;&lt;a href="index.html"&gt;Log out&lt;/a&gt;&lt;/li&gt;&lt;/div&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>