01.<?
02. mysql_connect("localhost","root","1111") or die(mysql_error());
03. mysql_select_db("newproject");
04.?>
05.<script type="text/JavaScript">
06.<!--
07.function MM_jumpMenu(targ,selObj,restore){
08. eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
09. if (restore) selObj.selectedIndex=0;
10.}
11.
12.</script>
13.</head>
14.<body>
15.<form action="show_ready.php" method="post" name="frmMain">
16. รายการโปรเจค
17. <select name="lmName1" OnChange="window.location='?item='+this.value;">
18. <option value=""><-- Please Select Item --></option>
19. <?
20. $strSQL = "SELECT * FROM project ORDER BY id_project ASC";
21. $objQuery = mysql_query($strSQL);
22. while($objResult = mysql_fetch_array($objQuery))
23. {
24. if($_GET["item"] == $objResult["id_project"])
25. {
26. $sel = "selected";
27. }
28. else
29. {
30. $sel = "";
31. }
32. ?>
33. <option value="<?=$objResult["id_project"];?>" <?=$sel;?>><?=$objResult["id_project"];?></option>
34. <?
35. }
36. ?>
37. </select>
38.
39. <?
40. if($_GET["item"] != "")
41. {
42. $strSQL = "SELECT * FROM project WHERE id_project = '".$_GET["item"]."' ";
43. $objQuery = mysql_query($strSQL);
44. $objResult2 = mysql_fetch_array($objQuery);
45. }
46.
47. ?>
48.
49.
50. <input type="hidden" name="hdnLine" value="<?=$objResult2["Nproject"];?>">
51. <input type="hidden" name="hdnLine2" value="<?=$objResult2["year"];?>">
52. <input type="hidden" name="hdnLine3" value="<?=$objResult2["priceLM"];?>">
53. <input type="hidden" name="hdnLine4" value="<?=$objResult2["Norg"];?>">
54.
55. <?
56. if($_GET["item"] != "")
57. {
58. $strSQL = "SELECT company.Ncompany, product.Nproduct
59. From present, product, company
60. WHERE company.id_company = present.id_company
61. AND product.id_product = present.id_product
62. and present.id_project = '".$_GET['item']."' ";
63. $objQuery = mysql_query($strSQL);
64. $objResult2 = mysql_fetch_array($objQuery);
65. $num_rows = mysql_num_rows($objQuery);
66.
67. }
68.
69. ?>
70. <input type="hidden" name="hdnLine5" value="<?=$objResult3["Nproduct"];?>">
71. <input type="hidden" name="hdnLine6" value="<?=$objResult3["Ncompany"];?>">
72. <? echo $objResult2["Ncompany"]; ?>
73.
74.
75. <label>
76. <input type="submit" name="Submit" value="เลือก" />
77. </label>
78.</form>
79.
80.
81.</body>
82.</html>
83.<?
84. mysql_close();
85.?>
