Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.28 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Pick a reviewee</title>
  4. </head>
  5. <body>
  6.  
  7. <h1>Select a Reviewee</h1>
  8. <form action="/360review/testinput.php" method="post">
  9. <?php
  10.  
  11. $linkID = odbc_connect("360review","","");
  12. $resultID = odbc_exec($linkID, "SELECT PM1,PM2,PM3,CM1,CM2,CM3,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12 FROM ProjectTable WHERE PNum = '$dropdown'");
  13.  
  14. echo '<select name="emps" value="options">';
  15. echo '<option>Choose a Reviewee ...</option>';
  16. $nbrow=0;
  17. while( odbc_fetch_row( $resultID ) )
  18. {
  19. $nbrow++;
  20. $pm1= odbc_result( $resultID, 1 );
  21. $pm2= odbc_result( $resultID, 2 );
  22. $pm3= odbc_result( $resultID, 3 );
  23. $cm1= odbc_result( $resultID, 4 );
  24. $cm2= odbc_result( $resultID, 5 );
  25. $cm3= odbc_result( $resultID, 6 );
  26. $t1= odbc_result( $resultID, 7 );
  27. $t2= odbc_result( $resultID, 8 );
  28. $t3= odbc_result( $resultID, 9 );
  29. $t4= odbc_result( $resultID, 10 );
  30. $t5= odbc_result( $resultID, 11 );
  31. $t6= odbc_result( $resultID, 12 );
  32. $t7= odbc_result( $resultID, 13 );
  33. $t8= odbc_result( $resultID, 14 );
  34. $t9= odbc_result( $resultID, 15 );
  35. $t10= odbc_result( $resultID, 16 );
  36. $t11= odbc_result( $resultID, 17 );
  37. $t12= odbc_result( $resultID, 18 );
  38.  
  39. if ($pm1 != "" ){
  40. echo "<option value>$pm1</option>";
  41. }
  42. if ($pm2 != "" ){
  43. echo "<option value>$pm2</option>";
  44. }
  45. if ($pm3 != "" ){
  46. echo "<option value>$pm3</option>";
  47. }
  48. if ($cm1 != "" ){
  49. echo "<option value>$cm1</option>";
  50. }
  51. if ($cm2 != "" ){
  52. echo "<option value>$cm2</option>";
  53. }
  54. if ($cm3 != "" ){
  55. echo "<option value>$cm3</option>";
  56. }
  57. if ($t1 != "" ){
  58. echo "<option value>$t1</option>";
  59. }
  60. if ($t2 != "" ){
  61. echo "<option value>$t2</option>";
  62. }
  63. if ($t3 != "" ){
  64. echo "<option value>$t3</option>";
  65. }
  66. if ($t4 != "" ){
  67. echo "<option value>$t4</option>";
  68. }
  69. if ($t5 != "" ){
  70. echo "<option value>$t5</option>";
  71. }
  72. if ($t6 != "" ){
  73. echo "<option value>$t6</option>";
  74. }
  75. if ($t7 != "" ){
  76. echo "<option value>$t7</option>";
  77. }
  78. if ($t8 != "" ){
  79. echo "<option value>$t8</option>";
  80. }
  81. if ($t9 != "" ){
  82. echo "<option value>$t9</option>";
  83. }
  84. if ($t10 != "" ){
  85. echo "<option value>$t10</option>";
  86. }
  87. if ($t11 != "" ){
  88. echo "<option value>$t11</option>";
  89. }
  90. if ($t12 != "" ){
  91. echo "<option value>$t12</option>";
  92. }
  93. }
  94. echo '</SELECT>';
  95. ?>
  96. </form>
  97.  
  98. </body>
  99. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement