Cross Table Drop Down Box

[Anon]

I apologise if there is already a posting for this but I don't know what it would be called?

I am creating an HTML form to enter data into an Orders table. One of the fields, I would like a drop down box of the Customers in the Customers table. (Presumably that is a good thing?)

Below is the static way of doing it, how can I point the drop down box at another table?

<form action="http://localhost/insert_orders.php" method="post">
<table border=0>
<tr><td>Customer</font></td><td>
<select name="searchtype">
<option value="Smith">Smith

<option value="Jones">Jones
</select><br></td></font></tr>

[cool-palace-ceo]

You want the php code that will show all input?

[Anon]

I just want the PHP code to select say the NAME field in the Customers table, so that when I enter an order (in the Orders table), I have a drop down list of existing Customers.