title: Using Dreamweaver, how can I populate a drop down list via PHP?
body: <p>I am trying to populate a drop-down list via PHP embedded in HTML.</p>
  
  <p>Here is what I have so far:</p>
  
  <pre><code>  &lt;select name="ChapterList" id="ChapterList" style="width:120px;"&gt;
      &lt;?php
      $username = "xxxxxxxxxxx";
      $password = "xxxxxxxxx";
      $database = "xxxxxxxxxxxxxx";
      $host = "xxxxxxxx.mydomainwebhost.com";
  
  @mysql_connect($host, $username, $password) or die("Unable to connect to database");
  @mysql_select_db($database) or die("Unable to select database");
  
  $query = "SELECT * FROM Chapters ORDER BY Id";
  
  $ListOptions = mysql_query($query);
  
  while($row = mysql_fetch_array($ListOptions))
  {
      echo "&lt;option value='".$row['Id']."'&gt;".$row['ChapterName']."&lt;/option&gt;"
  }
       ?&gt;
       &lt;/select&gt;
  </code></pre>
  
  <p>I know I am recieving the expected results because if I <code>echo $row['ChapterName'];</code> , the current values I have in the database are listed in the proper order, so why is it when I <code>echo "&lt;option value='".$row['Id']."'&gt;".$row['ChapterName']."&lt;/option&gt;"</code> my list receives nothing at all?</p>