如何使用while或for更改每个第五个单元格上的表行？

Question

Let's say we have a query that gives a result from database's records. I want to put those records on a table, but not like row after row. I would like to make a table that will change row on every fifth cell. How can I do this using while or for?

Here is just an example of what I have made for now, but I can't make it change row on every fifth cell...

<table>
<tr>
<?php $count = 0; while ($count <= 5){ ?>
<td><?php echo $id[$count]->id; $usrname[$count]->usrname;</td>
<?php $count++;}?>
</tr>
</table>

Any idea???

Answer 1

Use a modulo operation:

if($count % 5 == 4) {
  // end the current row, and start a new one
  echo "</tr><tr>";

It divides $count by 5 and takes the remainder. So once in every 5 steps, it is 4 (at $count is 4, 9, 14, etc) and you can generate something different for every fifth record.

---

If you apply this on your code example, you get this:

<table>
<tr>
<?php
$count = 0;
while ($count <= 5) {
  if($count % 5 == 4) {
    // Generate a new row
    echo "<\tr><tr>";
  }
  ?><td><?php echo $id[$count]->id." ".$usrname[$count]->usrname;?></td><?php
  $count++;
}
?>
</tr>
</table>