Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Pick a reviewee</title>
- </head>
- <body>
- <h1>Select a Reviewee</h1>
- <form action="/360review/testinput.php" method="post">
- <?php
- $linkID = odbc_connect("360review","","");
- $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'");
- echo '<select name="emps" value="options">';
- echo '<option>Choose a Reviewee ...</option>';
- $nbrow=0;
- while( odbc_fetch_row( $resultID ) )
- {
- $nbrow++;
- $pm1= odbc_result( $resultID, 1 );
- $pm2= odbc_result( $resultID, 2 );
- $pm3= odbc_result( $resultID, 3 );
- $cm1= odbc_result( $resultID, 4 );
- $cm2= odbc_result( $resultID, 5 );
- $cm3= odbc_result( $resultID, 6 );
- $t1= odbc_result( $resultID, 7 );
- $t2= odbc_result( $resultID, 8 );
- $t3= odbc_result( $resultID, 9 );
- $t4= odbc_result( $resultID, 10 );
- $t5= odbc_result( $resultID, 11 );
- $t6= odbc_result( $resultID, 12 );
- $t7= odbc_result( $resultID, 13 );
- $t8= odbc_result( $resultID, 14 );
- $t9= odbc_result( $resultID, 15 );
- $t10= odbc_result( $resultID, 16 );
- $t11= odbc_result( $resultID, 17 );
- $t12= odbc_result( $resultID, 18 );
- if ($pm1 != "" ){
- echo "<option value>$pm1</option>";
- }
- if ($pm2 != "" ){
- echo "<option value>$pm2</option>";
- }
- if ($pm3 != "" ){
- echo "<option value>$pm3</option>";
- }
- if ($cm1 != "" ){
- echo "<option value>$cm1</option>";
- }
- if ($cm2 != "" ){
- echo "<option value>$cm2</option>";
- }
- if ($cm3 != "" ){
- echo "<option value>$cm3</option>";
- }
- if ($t1 != "" ){
- echo "<option value>$t1</option>";
- }
- if ($t2 != "" ){
- echo "<option value>$t2</option>";
- }
- if ($t3 != "" ){
- echo "<option value>$t3</option>";
- }
- if ($t4 != "" ){
- echo "<option value>$t4</option>";
- }
- if ($t5 != "" ){
- echo "<option value>$t5</option>";
- }
- if ($t6 != "" ){
- echo "<option value>$t6</option>";
- }
- if ($t7 != "" ){
- echo "<option value>$t7</option>";
- }
- if ($t8 != "" ){
- echo "<option value>$t8</option>";
- }
- if ($t9 != "" ){
- echo "<option value>$t9</option>";
- }
- if ($t10 != "" ){
- echo "<option value>$t10</option>";
- }
- if ($t11 != "" ){
- echo "<option value>$t11</option>";
- }
- if ($t12 != "" ){
- echo "<option value>$t12</option>";
- }
- }
- echo '</SELECT>';
- ?>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement