01.<script language="javascript">
02. function resultName(Asset)
03. {
04. switch(Asset)
05. {
06. <?php
07.
08. mysql_connect("localhost","root","Abc@1234");
09. mysql_select_db("asset");
10. $strSQL ="select * from asset";
11. $objQuery = mysql_query($strSQL);
12. while($objResult = mysql_fetch_array($objQuery))
13. {
14. ?>
15. case "<?php echo $objResult["Asset"];?>":
16. form1.txtName1.value = "<?php echo $objResult["AssetName"];?>";
17. break;
18. <?php
19. }
20. ?>
21. default:
22. form1.txtName1.value = "";
23. }
24. }
25.</script>
26.
27. <select name="lmName1" OnChange="resultName(this.value);">
28. <option value=""><-- Please Select Item --></option>
29. <?php
30. mysql_connect("localhost","root","Abc@1234");
31. mysql_select_db("asset");
32. $strSQLs ="select * from asset";
33. $objQuerys = mysql_query($strSQLs);
34. while($objResults = mysql_fetch_array($objQuerys))
35. {
36. ?>
37. <option value="<?php echo $objResults["Asset"];?>"><?php echo $objResults["Asset"];?></option>
38. <?php
39. }
40. ?>
41. </select>
42.
43. </font></td>
44. <td width="8%">รายละเอียด</td>
45. <td width="47%"><input name="txtName1" type="text" disabled="disabled" value="" size="25"/></td>
