title: drop down only shows single value i have multiple value in my database
body: <p>This my code, using tables <code>upload-data</code>,<code>login</code>,<code>paper</code></p>
  <pre><code> &lt;!doctype html&gt;
      &lt;html&gt;&lt;head&gt;&lt;meta charset=&quot;utf-8&quot;&gt;
      &lt;title&gt;Untitled Document&lt;/title&gt;
      &lt;/head&gt;&lt;body&gt;
      &lt;table border=&quot;3&quot;&gt;&lt;tr&gt;
      &lt;th&gt;Paper id&lt;/th&gt;
      &lt;th&gt;Paper Name&lt;/th&gt;
      &lt;th&gt;Reviewer Name&lt;/th&gt;
      &lt;th&gt;Paper Status&lt;/th&gt;
      &lt;/tr&gt;
      &lt;?php $con=mysql_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;);
              mysql_select_db(&quot;conferencedb&quot;);
              $qry=&quot;select paperid,papername from paper&quot;;
              $rs=mysql_query($qry);
              
              $qry1=&quot;select (`username`) from login where type='reviewer'&quot;;
              $rs1=mysql_query($qry1);
              
              
              while($row=mysql_fetch_row($rs))
              {
                  if($row1=mysql_fetch_row($rs1))
                  {
              
                      echo &quot;&lt;tr&gt;&quot;;
                      echo &quot;&lt;td&gt;$row[0]&lt;/td&gt;&quot;;
                      echo &quot;&lt;td&gt;$row[1]&lt;/td&gt;&quot;;
                      echo &quot;&lt;td&gt;&lt;select name='type'&gt; 
  </code></pre>
  <p>only single option can fetch from the database</p>
  <pre><code>                        &lt;option value='$row1[0]'&gt;$row1[0]&lt;/option&gt;
                      &lt;/select&gt;&lt;/td&gt;&quot;;
                      echo &quot;&lt;td&gt;Pending&lt;/td&gt;&quot;;
                      echo &quot;&lt;/tr&gt;&quot;;
                  } 
              }
      ?&gt;
      
      
      &lt;/table&gt;
      &lt;input type=&quot;submit&quot;&gt;
      &lt;/body&gt;
      &lt;/html&gt;
  </code></pre>
  <p>above code is working ,but it retrieve only single row from the database: <code>$row1[0];</code>
  The current output window...i just marked area using
  paint.</p>