Displaying dynamic text from a drop-down menu

[digitalalias]

Hi All,

I am creating a form that requires text to automatically display on the form.

example:
The user picks an account number from the drop-down menu and the name, address, phone, etc is displayed on that same form in certain areas.

I'm using a MySQL db and PHP. I'm using dreamweaver to do my connections and record sets (makes life easier), but I'm too much of a novice to figure the code to produce this. Thanks for any help.

[bad76]

Hi,
the "user picks [...]" is a client side event.
So you can't do this just with php, that is server side and
don't know what happens on the client machine before it post the page.

So you need something like javascript.

You link any function to the ONCHANGE event of <select> and when the user picks a value this will reload the page passing the value. Now you can fill all field of page using the selected value.

This is the more PHP and less JAVASCRIPT way, I think.

(It's enough to do
<select ONCHANGE="document.location='<?=$PHP_SELF?>&sel='+this.value">
and when the page reload you can get the selected value in $sel or in $_GET['sel']...
)

I hope this helps you...