php - 如何限制 HTML 中的列数

Question

我将如何限制 HTML 表可以显示的列数。数据从 SQL 表中提取，然后显示在表中，但我只希望表显示 6 行，然后开始相反，它会向单行添加无限量，我该如何解决这个问题？

<?php
$con=mysqli_connect("localhost","Username","Password","Database");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($con,"SELECT * FROM menus");
echo "<table width='400'>";
echo "<tr>";
while($row = mysqli_fetch_array($result))
  {
echo'<td>';

?>

<a href="<?php echo $row['link']; ?>" class="tip" alt="<?php echo $row['game']; ?>">
<img src="<?php echo $row['picture']; ?>" alt="" width="150" height="120" class="fade" />
</td>

<?php
}
mysqli_close($con);
?>
</table>

Answer 1

$cols = 0;
echo '<table><tr>';
while($row = fetch()) {
  $cols++;
  if ($cols >= 6) {
     echo '</tr><tr>';
     $cols = 0;
  }
  echo '<td> ...</td>';
}
echo '</tr></table>';