01.<tr>
02. <td>TransponderId</td>
03. <td><select name="tid" OnChange="window.location='?vol='+this.value;">
04. <option value="">-- TransponderId --</option>
05. <?
06. $sql = "SELECT Id FROM `$tbl_name2` ORDER BY Id ASC";
07. $Query = mysql_query($sql);
08. while($Result = mysql_fetch_array($Query))
09. {
10. ?>
11. <option value="<?=$Result["Id"];?>"><?=$Result["Id"];?></option>
12. <?
13. }
14. ?>
15. </select></td>
16.
17. <?
18. if($_GET["vol"] != "")
19. {
20. $sql = "SELECT Id FROM `$tbl_name2` ORDER BY Id = '".$_GET["vol"]."' ";
21. $Query = mysql_query($sql);
22. $Result = mysql_fetch_array($Query);
23. $data = $Result["name"];
24. }
25. ?>
26. <input type="text" value="<?=$data;?>">
27. </tr>
