mysqli calling same data twice : <p>Can anyone explain a detailed answer as, am not able to found it on stackoverflow</p>

<pre><code>&lt;?php
  error_reporting(E_ALL);
  ini_set('display_errors', 1);
  ini_set('log_errors',1);
  mysqli_report(MYSQLI_REPORT_ALL);
   $link = mysqli_connect('localhost', 'root', '', 'test') or 
  die(mysqli_connect_error());
    $query2 = "Select * from qualifications";
    $result=mysqli_query($link,$query2)or die (mysqli_error($link));   
    ?&gt;
 &lt;form&gt;
  &lt;table&gt;
     &lt;tr&gt;
        &lt;td&gt;
           &lt;select name="short_term_degree" id="short_term_degree" &gt;
              &lt;option value=""&gt;Select&lt;/option&gt;
              &lt;?php
                 while ( $d=mysqli_fetch_assoc($result)) {
                  echo "&lt;option 
  value='".$d['qual_id']."'&gt;".$d['qualification']."&lt;/option&gt;";
                  }
                  ?&gt;
           &lt;/select&gt;
        &lt;/td&gt;
     &lt;/tr&gt;
     &lt;tr&gt;
        &lt;td&gt;
           &lt;select name="short_term_course" id="short_term_course" &gt;
              &lt;option value=""&gt;Select&lt;/option&gt;
              &lt;?php
                 while ( $d=mysqli_fetch_assoc($result)) {
                 echo "&lt;option 
  value='".$d['qual_id']."'&gt;".$d['qualification']."&lt;/option&gt;";
                 }
                 ?&gt;
           &lt;/select&gt;
        &lt;/td&gt;
       &lt;/tr&gt;
    &lt;/table&gt;
  &lt;/form&gt;
&lt;/body&gt;
</code></pre>

<p>Result I Got</p>

<pre><code>&lt;select name="short_term_degree" id="short_term_course"&gt;
 &lt;option value=""&gt;Select&lt;/option&gt;
 &lt;option value="268"&gt;Graduate&lt;/option&gt;
 &lt;option value="269"&gt;Mtech&lt;/option&gt;
 &lt;option value="353"&gt;Bachelor of Econimics&lt;/option&gt;
&lt;/select&gt;
&lt;select name="short_term_course" id="short_term_course"&gt;
 &lt;option value=""&gt;Select&lt;/option&gt;
&lt;/select&gt;
</code></pre>

<p>The Second Select Box Doesn't show any data What's the reason.</p>

<p>why do i require to use again  mysqli_query() before while OR mysqli_data_seek($result,0);
for getting result in select box</p>
