Well, it won't be immediate, because it has to query the server, but yeah, it's possible. On the drop down menu, add:
<select onchange="document.formName.submit()">
where formName is the name of your form. Then, set the form's action to the PHP script, and the PHP script will take the selected value from the drop down menu, query the database and output the details.
Diego