title: Can't get multiple result in td
body: <p>I have this problem in displaying the result in <code>td inside table</code>. I want to display all rows coming from the database.
  I have code but it results only one <code>row</code>.</p>
  
  <pre><code>&lt;table class="table table-striped table-bordered table-hover" id="dataTables"&gt;
      &lt;thead&gt;
          &lt;tr&gt;
              &lt;th&gt;ID&lt;/th&gt;
              &lt;th&gt;Role&lt;/th&gt;
              &lt;th&gt;Description&lt;/th&gt;
          &lt;/tr&gt;
      &lt;/thead&gt;
      &lt;tbody&gt;
          &lt;?php 
              $con=mysqli_connect("localhost", "root", "", "trackingsys"); 
              if (mysqli_connect_errno()) { 
                  echo "Failed to connect to MySQL: " . mysqli_connect_error(); 
              }
              $query="SELECT * from role" ; 
              $result = mysqli_query($con,$query); 
              while ($row = mysqli_fetch_assoc($result)) { 
                  echo '&lt;tr&gt;'; 
                      echo "&lt;td&gt;" . $row['ID'] . "&lt;/td&gt;"; 
                      echo "&lt;td&gt;" . $row['RoleName'] . "&lt;/td&gt;"; 
                      echo "&lt;td&gt;" . $row['RoleDesc'] . "&lt;/td&gt;"; 
                  echo '&lt;/tr&gt;';
              } 
              mysqli_close($con); ?&gt;
      &lt;/tbody&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>I edited this <code>code and put the ending tag</code> <code>&lt;/td&gt;</code>. But still it results only <code>one row.</code></p>