Code: Select all
<select name="select1" id="select1" onChange='empsel()'/> q
<?php
$result = mysql_query("SELECT fullname FROM employee");
while ($row = mysql_fetch_array($result)) {
echo "<option>".$row['fullname']."</option><br>";
};
?>
<option>New Employee</option>
</select>
<br/>
<br/>
<br/>
<br/>
<textarea name="select2" rows="5" cols="15" id="select2"/>
<?php
$tmpVar = $_POST['select1'];
$result = mysql_query("SELECT ssn, dob, add1, add2, phone, empid, position, hiredate, termdate, status, salary, driverslicense FROM employee WHERE fullname = '$tmpVar' ");
while ($row = mysql_fetch_array($result)) {
echo "".$row['ssn']."|"."".$row['dob']."|"."".$row['add1']."|"."".$row['add2']."|".
"".$row['phone']."|"."".$row['empid']."|"."".$row['position']."|"."".$row['hiredate']."|".
"".$row['termdate']."|"."".$row['status']."|"."".$row['salary']."|"."".$row['driverslicense']."|";
};
?>
</textarea>It loads john smith's information from the database into the textarea like it should.
Any ideas?