title: PHP add html break after every 10th mysql result
body: <p>I am having a trouble with my code. What I am trying to achieve:</p>
  
  <p>I have a database table called "matches", containing info about football fixtures. For now i have around 100 matches in this table, but soon to be 500+, so to not to blow my viewers minds, i want my code to perform a line break (or maybe a new table row, thats not important now, just some HTML tag) after every 10th result is shown(because every week there are 10 matches)</p>
  
  <p>Here is my PHP code:</p>
  
  <pre><code>$sql = "SELECT * FROM matches ORDER BY matchid ASC";
  $query = mysqli_query($Connection, $sql) or die (mysqli_error($sql));
  $fixtures='';
  while($row = mysqli_fetch_array( $query )) { 
      $fixturetime = $row["time"];
      $fixturetime2 = $row["time"];
      $fixtureid = $row["matchid"];
      $fixtureround = $row["round"];
      $hometeamid = $row["hometeamid"];
      $awayteamid = $row["awayteamid"];
      $fixturetime = strtotime( $fixturetime );
      $fixturetime = date( 'd.m.Y', $fixturetime );
      $fixturetime2 = strtotime( $fixturetime2 );
      $fixturetime2 = date( 'H:i', $fixturetime2 );
  
      $fixtures.='&lt;tr&gt;&lt;td&gt;&lt;strong&gt;' .$hometeamname. '&lt;/strong&gt; v. &lt;strong&gt;' .$awayteamname. '&lt;/strong&gt;&lt;/td&gt;&lt;td&gt;' .$fixturetime. '&lt;/td&gt;&lt;td&gt;' .$fixturetime2. '&lt;/td&gt;&lt;td style="text-align: right;"&gt;' .$fixtureid. '&lt;/td&gt;&lt;td&gt;' .$i. '&lt;/td&gt;&lt;/tr&gt;';
  }
  </code></pre>
  
  <p>And here is HTML output:</p>
  
  <pre><code>&lt;table&gt;
      &lt;?php echo $fixtures; ?&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>I have tried some methods shown on stackoverflow, but I was not able to implement them properly to my solution. Because I am kinda new to PHP I am asking for specific solution. </p>
  
  <p>Thank you.</p>