dropdown menu linked with query

[burge124]

hi i have a drop down menu with a list of chapters for a user to choose from, how can i use the query so that it changes depending upon the users selection?

 

        <form id="form1" name="form1" method="post" action="">
          <label>Chapter Selection
          <select name="chapterselect" size="1" id="chapterselect">
            <option>0</option>
            <option>1</option>
            <option>2</option>
          </select>
          </label>
                </form>
        <p>
          <label></label>

 

<?php
$result = mysql_query("SELECT * FROM question WHERE chapterid = 1 ORDER BY QuestionID"); 
?>