on dropdown从数据库和填充文本框更改事件加载数据

Question

I have a simple dropdown list, whose values are from the DB.I am doing it as

$query = "SELECT id,location_name FROM misc_location";
if ( $result = mysql_query($query) ) {
    $selectLoco = "<select name='selectLoco' id='selectLoco'>";
     while ($row = mysql_fetch_row($result) ) {
        $selectLoco .= "<option value='$row[0]''> $row[1] </option>";
     }
     $selectLoco .= "</select>";
} 

But now i have a text box below the dropdown. So when user selects a dropdown item ,I need to pull a value corresponding the item selected and display in the text box.

Table : misc_location

id   location_name   time
1    Ben             7.00 am
2    Cat             8.00

Location : Drop-down user selects Ben , Text box below should display 7.00

Answer 1

I got a work around , based on the answers using ajax + json here its how i did it

The jquery

$('#selectLoco').on('change', function(){
    selectLoco = $('#selectLoco option:selected').val(); // the dropdown item selected value
    $.ajax({
        type :'POST',
        dataType:'json',
        data : { selectLoco : selectLoco },
        url : 'getresult.php',
        success : function(result){
         $('#textBoxIwant).val(result['WeekDaySm']);// json result      
        }
    });

});

The PHP

<?php 
require_once ('../config/db.config.php');

$selectLoco = $_POST['selectLoco'];
$query = "SELECT * FROM misc_location WHERE id = '$selectLoco' ";

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
echo json_encode($row);
 ?>