title: MySQL fetch_assoc() shows 1 less result
body: <p>i have a table like below:</p>
  
  <pre><code>hub dep
  A B
  A C
  B D
  B E
  B F
  E G
  </code></pre>
  
  <p>i use mysql select to get query and my code is like below:</p>
  
  <pre><code>$sql         = "SELECT dep FROM handd WHERE hub='B'";
          $result      = $conn-&gt;query( $sql );
          $row         = $result-&gt;fetch_assoc();
  
          while($row = $result-&gt;fetch_assoc()) {
      echo "id: " . $row["dep"]."&lt;br&gt;";
  }
  </code></pre>
  
  <p>but it just gives me result like below:</p>
  
  <pre><code>id: E
  id: F
  </code></pre>
  
  <p>and i am wondering where is D?</p>