[mdhall]

I hope this is an easy answer for someone. I have customer info, including names and addresses, stored in a database. The field names are name, address, city, state, zip.

I have a form for a program I am developing to enter customer orders. One part of the form has a dropdown list populated from the database which brings up the saved customer names ( for example, Customer 1, Customer 2, etc., and this works fine ), and looks like this...

Sold To:<?php include("customer_list.php"); ?>

Following that is a textarea for a shipping address, which is pretty basic...

Ship to:<br>
<textarea name=ship_to cols=30 rows=4></textarea>

I'm wondering if its possible so that when I select a customer name from the dropdown, the "Ship To" textarea will automatically display the selected customers' address in the "Ship to" textarea so that it doesn't have to be manually typed in?
Customer_list.php ( if it helps any )...

php: include("dbinfo.inc.php");
$conn = mysql_connect("$location","$username","$password");

if (!$conn) die ("Could not connect MySQL");
mysql_select_db($database,$conn) or die ("Could not open database");
$sql="SELECT * FROM customers";
$result=mysql_query($sql);

$options="";

while ($row=mysql_fetch_array($result)) {
$name=$row["name"];
$options.="<OPTION VALUE=\"$name\">".$name;
}
?>

<SELECT NAME=name>
<OPTION VALUE=0>Select Customer
<?=$options?>
</SELECT>

Thnx....

[blaw]

Hello,

Just like the one I replied to before this, you can use a combo of Javascript and PHP. OnChange is a popular event to do this. Pass the parameter according to the selection made, and retrieve the information ("Ship to:") and display it. Alternatively, you can choose to have all the Ship To info loaded onto JavaScript and switch it after the page is loaded, depending on which combobox item is selected. That way, you don't have to load the page again when the selection is made. Whichever suits your needs better, I guess.