How to display information when option changes?
<p>I have a drop down menu below:</p>

<pre><code>&lt;select name="session" id="sessionsDrop"&gt;
&lt;option value=""&gt;Please Select&lt;/option&gt;
&lt;option value='20'&gt;EWYGC - 10-01-2013 - 09:00&lt;/option&gt;
&lt;option value='22'&gt;WDFRK - 11-01-2013 - 10:05&lt;/option&gt;
&lt;option value='23'&gt;XJJVS - 12-01-2013 - 10:00&lt;/option&gt;
&lt;option value='21'&gt;YANLO - 11-01-2013 - 09:00&lt;/option&gt;
&lt;option value='24'&gt;YTMVB - 12-01-2013 - 03:00&lt;/option&gt;
&lt;/select&gt; &lt;/p&gt; 
</code></pre>

<p>Below I have a Multiple Select box where it displays a list of students that is taking the select assessment from the drop down menu above:</p>

<pre><code>$studentactive = 1;

$currentstudentqry = "
SELECT
ss.SessionId, st.StudentId, st.StudentAlias, st.StudentForename, st.StudentSurname
FROM
Student_Session ss 
INNER JOIN
Student st ON ss.StudentId = st.StudentId
WHERE
(ss.SessionId = ? and st.Active = ?)
ORDER BY st.StudentAlias
";

$currentstudentstmt=$mysqli-&gt;prepare($currentassessmentqry);
// You only need to call bind_param once
$currentstudentstmt-&gt;bind_param("ii",$sessionsdrop, $stuentactive);
// get result and assign variables (prefix with db)

$currentstudentstmt-&gt;execute(); 

$currentstudentstmt-&gt;bind_result($dbSessionId,$dbStudentId,$dbStudentAlias,$dbStudentForename.$dbStudentSurname);

$currentstudentstmt-&gt;store_result();

$studentnum = $currentstudentstmt-&gt;num_rows();   

$studentSELECT = '&lt;select name="studenttextarea" id="studentselect" size="6"&gt;'.PHP_EOL;      

if($studentnum == 0){

$studentSELECT .= "&lt;option disabled='disabled' class='red' value=''&gt;No Students currently in this Assessment&lt;/option&gt;"; 


}else{   

while ( $currentstudentstmt-&gt;fetch() ) {

$studentSELECT .= sprintf("&lt;option disabled='disabled' value='%s'&gt;%s - %s s&lt;/option&gt;", $dbStudentId, $dbStudentAlias, $dbStudentForename, $dbStudentSurname) . PHP_EOL; 
}

}

$studentSELECT .= '&lt;/select&gt;';
</code></pre>

<p>But I have a little problem, I need a way to be able to display the list of students in the select box when the user has selected an option from the drop down menu. The problem with the php code is that the page has to be submitted to find its results.</p>

<p>My question is that is there a way that javascript/jquery can be combined so that the php code above can look for the students that takes the chosen assessments but be able to use javascript/jqeury to display the student information in the select box when assessment is chosen in drop down menu?</p>
