PHP jQuery mySQL Populating DROPDOWN Fields error

Question

I am trying to populate the second dropdown from my choice in the second, but whenever I make my change nothing updates.

<script type="text/javascript" src="jquery-1.7.2.js"></script>

<script>
var second_choice = $('#second-choice').val();
$("#first-choice").change(function() {
$("$second-choice").load("findModel.php?choice=" + $("#first-choice").val());
});
</script>

Here is the associated PHP File:

<?php
include 'dbc.php';

$choice = mysql_real_escape_string($_GET['choice']);

$query="SELECT * FROM `cars` WHERE `DVLAMake`='$choice'";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {
    echo "<option>" . $row{'DVLAModel'} . "</option>";
}
?>

The database connection works.

...

<select id="first-choice">
<option selected value="base">Please Select a Make</option>
<?php 
$sql="SELECT DISTINCT `DVLAMake` FROM `cars`";
$result = mysql_query($sql);
while ($data=mysql_fetch_assoc($result))
{
echo "<option value =\"{$data[DVLAMake]}\" >{$data[DVLAMake]}</option>\n";
} 
?>
</select>

<select id="second-choice">
<option>Please choose from above</option>
</select>
<br />

<input type="submit" style="font-size:14px; padding:3;"value="Submit" size="20" />
</form>

...

Any reason why?

Typo: $second-choice should be #second-choice Proof read a bit more ;-) — Flukey
– Flukey, Commented Apr 5, 2012 at 10:02

Nicola Peluchetti · Accepted Answer · 2012-04-05 10:14:27Z

4

You have a typo here $("$second-choice")

$("#second-choice").load("findModel.php?choice=" + $("#first-choice").val());

EDIT - have you tried

$(function(){
    var second_choice = $('#second-choice').val();
    $("#first-choice").change(function() {
        $("$second-choice").load("findModel.php?choice=" + $("#first-choice").val());
    });
});

edited Apr 5, 2012 at 10:14

answered Apr 5, 2012 at 10:00

Nicola Peluchetti

76.9k32 gold badges150 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nicola Peluchetti Over a year ago

@Mombassa i edited my answer, but with firebug do you see the call?Maybe you didn'0t bind the change event because you didn't use the ready() handler

Collectives™ on Stack Overflow

PHP jQuery mySQL Populating DROPDOWN Fields error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related