How do I get an option select to populate from MySQL data?
How do I get an option select to populate from MySQL data? It populates to a textarea just fine when a dummy option is selected.
<html>
<head>
<title>Populate Dropdown...NOT</title>
<link rel="stylesheet" type="text/css" href="load2.css" media="screen">
<script src="http://code.jquery.com/jquery-1.4.4.js"></script>
<script type="text/JavaScript">
$(function() {
$('#nameSelect').change(function() {
$.get('getDetails.php', {name: $(this).val()},
function(data) {
$('#details').val(data);
}
);
});
});
</script>
</head>
<body>
<div class="right">
<p>
<table border="1" bgcolor="#DDDDDD">
<tr>
<td>Use Existing Asset ID:</td>
<td><select name="name" id="nameSelect" style="width:95px;">
<option>Ford</option>
<opti开发者_运维百科on>Chevy</option>
</select></td>
</tr>
<tr>
<td>Existing Ticket Status: </td>
<td><input type="text" size="12" maxlength="36" id="ticket_status" name="ticket_stat"></td>
</tr>
<tr>
<td>Existing Prob. Desc: </td>
<td><input type="text" size="12" maxlength="36" id="problem_desc" name="problem_desc"></td>
</tr>
<tr>
<td>Existing Priority Code: </td>
<td><input type="text" size="12" maxlength="36" id="priority_code" name="priority_code"></td>
</tr>
</table>
</p>
</div>
<div id="Div4">
<textarea id="details" rows="20" cols="40"></textarea>
<div>
</body>
</html>
One way is to create a server side ajax function that returns a json arary of results, then for each result in the array you need to $('#yourSelect').append('<option>'+returnedArray[i]+'</option>')
精彩评论