[Resolved] Using PHP, MySQL, and javascript

[dwilson]

Does anybody know how to create a javascript array using php to get the data from a MySQL database. The reason is I have a drop down box filled with user names. What I want to do is display the user id next to the drop down box using a input box or something. The reason I want to use a javascritp array is so when a user clicks a name in the drop down box it will automatically fill in the input box with the users id number, without doing a page refresh.
Using a javascript array is the only way I can think of accomplishing what I want to do with out a page refresh
I'm knew to javascript as well as PHP so I can use all the help I can get.

[stolzyboy]

well once you populate the select box with mysql data via php, you simply have an html select box, nothing more, nothing less, so you can then use JS to add that value to the text field by having the select box, call a function you write that places the value in the text field with the onchange function

something like this should get you rolling, don't cut and paste, it may work, but is off the top of my head and UNtested!!!

<script language="JavaScript1.2">
function changer(){
var value = document.formname.selector.options[document.formname.selector.selectedIndex].value;
document.formname.textfield.value = value;
}
</script>

<form name="formname">
<select name="selector" onchange="changer();">
option...
option...
populate with mysql/php
</select>

<input type="text" name="textfield">

[dwilson]

Thanks stolzyboy for your help, with a little bit of modification it worked just like I wanted it to