Select a region based on a country selected

[mso5]

Hi,

I am trying to build a small form with a list of countries and regions by each country (yes, the classical one), and I'm stuck with it. I'm using AJAX also, and I manage to get the correct value from the selection, but it does not modify the second list based on the first selection. Can anyone tell me what am I doing wrong in this code? I am not a programmer..

Thank you!

<script language="javascript" type="text/javascript">
<!-- 
//Browser Support Code
function ajaxFunction(){
    var ajaxRequest;  // The variable that makes Ajax possible!
 
    try{
        // Opera 8.0+, Firefox, Safari
        ajaxRequest = new XMLHttpRequest();
    } catch (e){
        // Internet Explorer Browsers
        try{
            ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
        } catch (e) {
            try{
                ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
            } catch (e){
                // Something went wrong
                alert("Your browser broke!");
                return false;
            }
        }
    }
    // Create a function that will receive data sent from the server
    ajaxRequest.onreadystatechange = function(){
        if(ajaxRequest.readyState == 4){
            document.getElementById("selCount").innerHTML=ajaxRequest.responseText;
        }
    }
 
    var selCountry1 = document.getElementById("selCountry").value;
    alert(selCountry1);
    var queryString = "?selCountry=" + selCountry1;
 
 
ajaxRequest.open("POST", "despre_dealeri_ajax1.php" + queryString, true);
ajaxRequest.send(null); 
}
//-->
</script>

 
 <?php 
 
$db_countries = mysql_query("SELECT id, name FROM country") or die(mysql_error());
$db_cities = mysql_query("SELECT DISTINCT id,name FROM region WHERE country_id = '".$_POST['selCount']."'") or die(mysql_error());
//echo $_POST['selCountry'];
$db=mysql_query("SELECT * FROM region WHERE id = \"".$_POST['selCity']."\"")or die(mysql_error());
?>
 
 
 
<div id="content"> 
  <div id="text"> 
    <h1><span>Dealeri</span></h1>
    Cauta dealeri din: 
    <form name="frmDealer" action="despre_dealeri_ajax1.php" method=post enctype="multipart/form-data" >
      <INPUT type=hidden name="selCount">
      <SELECT name="selCountry" onChange="ajaxFunction();"/>
      <OPTION value="">SELECT ONE</OPTION>
        <?php 
 
            while($re1=mysql_fetch_array($db_countries))
            {
 
        ?>
        <OPTION value="<?php echo $re1['id']; ?>" ><?php echo $re1['name']." ".$re1['id']; ?></OPTION>
        <?php
        }
        ?>
      </SELECT>
      &nbsp;&nbsp;&nbsp;&nbsp;
      <SELECT name="selCity"/>
      <OPTION value="">SELECT ONE</OPTION>
        <?php 
            $i=0;
            while($re11=mysql_fetch_array($db_cities))
            {
            $i++;
        ?>
        <OPTION value="<?php echo $re11['id']; ?>" <?php echo ($i==1?" DEFAULT":"");  ?>><?php echo $re11['name']; ?></OPTION>
        <?php
        }
        ?>
      </SELECT>
      <!-- <INPUT type=submit value="&nbsp;Afiseaza&nbsp;" name=btnSubmit> -->
    </form>

[ajcolburn]

At a glance, your javascript uses the getElementById method, but your form inputs do not have id's. Make sure that any elements used with this method have an id, for example:

<INPUT type=hidden name="selCount" id="selCount" />
<SELECT name="selCountry" id="selCountry" onChange="ajaxFunction();"/>

[FullyH3ktik]

or you could use getElementsByName, when you use the getElementsByName method, all elements in the document that have the specified name attribute or id attribute value are returned.
ajcolburn & mso5, please use code tags when posting code, it makes it a lot easier to read and resolve your problem

[pbmods]

mso5 and ajcolburn:

Please use CODE tags when posting source code:

[CODE=html]
HTML code goes here.
[/CODE]

etc.