change value according to selection

[funbinod]

how can we change a value in another input field while changing the selection on another field.

 

like

 

if any name is selected in "name" field then his/ her stat recorded in database be appeared automatically on another input field or elsewhere.

 

is it possible?

 

i tried something on jQuery but could not reach anywhere...

[justsomeguy]

One solution would be to use Javascript to put a change event on the dropdown field, and the event handler gets the value that is selected and sends it to PHP with an ajax request, PHP looks up the corresponding value in the database and sends it back to Javascript, and then Javascript updates the field with the value from PHP.