Databases
StackOverflow2013
Postsdbo
POChange data of second combo box,onchange of the first one
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POChange data of second combo box,onchange of the first one
    text
    copied!<p>I am having 2 combo boxes.in the 1st one has state names I have data retrieved from the database,second one has to districts of that particular state.what I need is that on onchange in data in the first combobox.data in the second should also be changed.here is my code.</p> <pre><code>&lt;select name="district" id="district" onchange="showcomplain()"&gt; &lt;?php $query="SELECT * FROM `rev_district_master`"; $result=mysql_query($query) or die("Selection query of District Master is Error".mysql_error()); $num = mysql_numrows($result); while($row=mysql_fetch_row($result)) { ?&gt; &lt;option value="&lt;?php echo $row[1];?&gt;"&gt;&lt;?php echo $row[1];?&gt;&lt;/option&gt; &lt;?php } ?&gt; This is my ajax file: function stateComboChange(){ xmlHttp=GetXmlHttpObject(); if (xmlHttp==null) { alert ("Browser does not support HTTP Request"); return; }else{ var url="./ajax/list1.php"; xmlHttp.onreadystatechange=stateChanged1 ; xmlHttp.open("POST",url,true); xmlHttp.send(null) ; } } function GetXmlHttpObject() { var xmlHttp=null; try { // Firefox, Opera 8.0+, Safari xmlHttp=new XMLHttpRequest(); } catch (e) { //Internet Explorer try { xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp; } function stateChanged1() { if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ document.getElementById("stateCombo").innerHTML=xmlHttp.responseText; } </code></pre> <p>}</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload