Need to rertrieve and decode JSON data sent to  PHP programs from AJAX 

and any additional help with the Country , State, City Dropdown List Jquery Ajax program

would be greatly appreciated.

 

 

 

<SCRIPT>
    function loadcountries(){
          $.ajax(
 
           url          : "GETCOUNTRIES.PHP";
     data         :
    
    
     dataType     : JSON
              ResponseType : JSON
     async        : true
     success   ( function(countries) {
          var cbocontrol = $("#COUNTRYCBO");
          for ( N=0 ; N < countries.Length ; N++ ){
                         CBOCONTROL.append($("<option value='" + countries[COUNTER].countrycod + "'>" + countries[COUNTER].countrynam +  "</option>"));
                   }      
    });
          });
    $("#COUNTRYCBO").onchange(function(){
          $.ajax(
                   type        : POST
                    url          : "GETSTATES.PHP";
                    data         :{"COUNTRYCOD":"COUNTRYCBO.val()"}
         
                    dataType     : JSON
                     ResponseType : JSON
                     async        : true
                     success   ( function(states) {
                              var cbocontrol = $("#STATECBO");
                              for ( N=0 ; N < states.Length ; N++ ){
                                     CBOCONTROL.append($("<option value='" + states[COUNTER].statecod + "'>"  +   states[COUNTER].statenam +  "</option>"));
                               }      
                       })
                });
      });  
            $("#STATECBO").onchange(){
              
      $.ajax(
                 type         : "POST"
                 url          : "GETCITIES.PHP";
                data         : {"COUNTRYCOD":"COUNTRYCBO.val()","STATECOD": "STATECBO.val()"}
                dataType     : JSON
                ResponseType : JSON
                async        : true
                success   ( function(cities) {
                var CITY = $("#CITYCBO");
                   for ( N=0 ; N < cities.Length ; N++ ){
                                       CITY.append($("<option value='" + cities[COUNTER].CITYCOD + "'>" + cities[COUNTER].CITYNAM +  "</option>"));
                   }      
                     })
                   });
            });
        
  
     </SCRIPT>

 

 

 

 

          GETSTATES.PHP
 
  ?php  
          $hostname       ="localhost";
          $password       ="";
          $username       ="root";
          $CON            =mysql_connect ($hostname, $username, $password) ;
       mysql_select_db("REGGAEDBF", $CON);
 
          $SQLSTATES = " SELECT * FROM STATES ";
          $SQLSTATES.= " WHERE  COUNTRYCOD=" . $COUNTRYCOD ;
          $FSTATES   = mysql_query( $SQLSTATES, $CON );
          while ( $ROW = mysql_fetch_array($FSTATES)) {
                   STATE = array(
                      'STATECOD' => $ROW['STATECOD'],
                         'STATENAM' => $ROW['STATENAM']);
          }
          echo(json_encode($STATE));
   ?>
  
  
              GETCITIES.PHP
  
  
  
  
   <?php  
         $hostname       ="localhost";
         $password       ="";
         $username       ="root";
         $CON            =mysql_connect ($hostname, $username, $password) ;
      mysql_select_db("REGGAEDBF", $CON);
 
        $SQLCITIES = " SELECT * FROM CITIES ";
        $SQLCITIES.= " WHERE  COUNTRYCOD=" . $COUNTRYCOD ;
      $SQLCITIES.= " AND      STATECOD=" . $STATECOD;
        $FCITY     = mysql_query( $SQLCITIES, $CON );
        while ( $ROW = mysql_fetch_array($FCITY)) {
        CITY = array(
          'CITYCOD' => $ROW['CITYCOD'],
             'CITYNAM' => $ROW['CITYNAM']);
   }
   echo(json_encode($CITY));
   ?>