Populating textboxes upon drop down selection
Posted on 2006-03-27
I finally thought that I had found the answer to my dilema, but not quite yet. I have the following code which populates ONE textbox when the user makes a selection. I actually need TWO textboxes to be populated, but unfortunately, the code that I have doesn't seem do be built to just add a little more code to satisfy this need. Here's the code:
//Connect to the db.
$dbc = mysql_connect('localhost','root','');
<form method=\"POST\" name=\"myform\" action=\"add_scan.php\">
<p>Account Number:<input type=\"text\" name=\"ldgact\" size=\"50\"></p>
<p>Production Date:<input type=\"text\" name=\"datprd\" size=\"10\"></p>>";
$query="SELECT APPNBR, CUSTNAME, DATPRD FROM tblappearance, tblcustomers WHERE tblappearance.ldgact=tblcustomers.mcustnbr";
echo "<option value='$custname'\">".$appnbr."</option>";
Any suggestions will be welcome. Thanks!