Hopefully someone here can help me... I am drawing a complete blank and feel like an idiot but here goes....

I am trying to get a drowdown box populated by field b of table A to OnSelect display field b of table B in a textbox below (note: field a of both is id) underneath

the text box it would have update to effect changes if necessary (this part if optional - probably better to have it updated on an admin screen.) Anyway im

stuck...got the javascript/php/mysql to popluate to the dropdown no probably then drew a blank.

I have tried countless way to effect the proper result. Still having trouble. Below is the latest code tried.

Thanks for you help.



<table width="100%" align="center" cellspacing="0" cellpadding="0">
<tr valign="bottom">
<td width="50%" align="right">
<font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<form name="testing" method="GET" action="<?=$PHP_SELF?>">
Filter by
<select name="testing">
require ("db.php");
$result = mysql_query("SELECT * FROM title ORDER BY id");
$query = "SELECT * FROM title ORDER BY id ASC";
function displayerror($message) {
printf("<span class=\"formerror\">%s</span>\n", $message);
if (!($result = mysql_query($query))) {
displayerror(sprintf("Internal ****ed up error %d:%s\n", mysql_errno(), mysql_error()));
} // end if
if($result) {
<option value="<? echo $row['id']; ?>"><? echo $row['title']." ".$row[''];?></option>
} // end while
} // end if
</select> <p>&nbsp;
<textarea name="n" cols="60" rows="10" ><?php echo $row ?></textarea>