Click here to Skip to main content
15,867,756 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have cascading drop down box on a page but it not return data when first drop down value is selected.

PHP
 <?php
                                                      $project_name=mysql_query("select main_unit_id,project_name from main_unit");
?>
<select name="project" id="project" tabindex="1">
 <option value=''>--Select Project --</option>
<?php while($rows=mysql_fetch_array($project_name)) { ?>
<option value="<?php echo $rows['main_unit_id']; ?>"><?php echo $rows["project_name"]; ?></option>
<?php } ?>
?>
<select>


<div id="activity"></div>



JavaScript
<script src="js/jquery-1.9.0.min.js"></script>
  <script language="javascript">
  $(document).ready(function(){
  $("select#project").change(function(){

    var main_unit_id =  $("select#project option:selected").attr('value');
    $("#activity").html( "" );
    if (main_unit_id.length > 0 ) {
      alert(main_unit_id);
     $.ajax({
        type: "POST",
        url: "fetch_activity.php",
        data: "main_unit_id="+main_unit_id,
        cache: false,
        success: function(html) {
          $("#activity").html(html);
        }
      });
    }
  });
  });
  </script>




and fetch_activity.php is

PHP
<?php
include "conn/conn.php";
$main_unit_id = trim(mysql_escape_string($_POST["main_unit_id"]));
$sql = SELECT activity_id, activity_name FROM activities WHERE main_unit_id = '".$main_unit_id."'";
$count = mysqli_num_rows( mysqli_query($con, $sql) );
if ($count > 0 ) {
$query = mysqli_query($con, $sql);
?>
<label>
<select name="activity" id="activity">
  <option value="">Please Activity</option>
  <?php while ($rs = mysqli_fetch_array($query, MYSQLI_ASSOC)) { ?>
  <option value="<?php echo $rs["activity_id"]; ?>"><?php echo $rs["activity_name"]; ?></option>
  <?php } ?>
</select>
</label>
<?php
  }
?>
Posted
Updated 5-Feb-15 5:13am
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900