código:
<script> $(document).ready(function(){ $(".field").change(function(){ field = $(".field").val(); $.ajax({ type:"POST", data:{"field":field}, url:"potential-courses.php", success:function(data){ $(".course").val(data); } }); }); }); </script>cursos-potenciales.php
<?php include("conn.php"); $field = $_POST['field']; $sql = "select * from course_master where field = '$field' order by course_full_name"; $result = mysqli_query($link,$sql); while ($row = mysqli_fetch_array($result)) { echo "<option value=".$row['course_short_name'].">".$row['course_full_name']."</option>"; } ?>código HTML:
<select name='field' class='field' id="field"> <option value="">Select Field</option> <option value='engineering'>Engineering</option> <option value='law'>LAW</option> <option value='medical'>Medical</option> <option value='management'>Management</option> <option value='pharmacy'>Pharmacy</option> <option value='hotel management'>Hotel Management</option> <option value='mass communication'>Mass Communication</option> <option value='agriculture'>Agriculture</option> <option value='architecture'>Architecture</option> <option value='education'>Education</option> <option value='paramedical'>Paramedical</option> <option value='design'>Design</option> <option value='commerce'>Commerce</option> <option value='film/tV/media'>Film /TV/ Media</option> </select> <select name="course" class="course"> <option value="">Select Courses</option> </select>En este código tengo dos listas desplegables, es decir
<select name='field' class='field' id="field">y otro es
<select name="course" class="course">cuando cambio el valor de "nombre=campo" no muestra nada en "nombre=curso". donde estoy haciendo mal por favor ayúdame.
Gracias
Cambialo:
$(".course").val(data);para
$(".course").html(data); Agregará el conjunto <option> que ha devuelto de php a su <select>