MySQL-如何在多列html表中显示,MySQL表的单列


MySQL - How to show in multiple columns html table, single column of mysql table

我想知道如何在我的php文件中用html显示一个有多列的表,但在该表中,列只显示来自mysqli 的单列结果

我现在拥有的是:

<?php
include "dbinc.php";
$con=mysqli_connect($servername,$username,$password,$database);
$letramasculinos = mysqli_query($con,"SELECT nome FROM nomes WHERE nome LIKE '$_POST[letra]%' AND sexo = 'm';");
$letrafemininos = mysqli_query($con,"SELECT nome FROM nomes WHERE nome LIKE '$_POST[letra]%' AND sexo = 'f';");
     (more code...)
echo "<table style='display: inline-block;' width='150px' border='1' bgcolor='#6699FF'>";
while($row = mysqli_fetch_array($letramasculinos))
{
echo "<tr>";
echo "<td><center>" . $row['nome'] . "</center></td>";
echo "</tr>";
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
echo "<table style='display: inline-block;' width='150px' border='1' bgcolor='#FF99FF'>";
while($row = mysqli_fetch_array($letrafemininos))
{
echo "<tr>";
echo "<td><center>" . $row['nome'] . "</center></td>";
echo "</tr>";
}
echo "</table>";
}
     (more code...)
?>

在这个示例代码中,它显示了2个有1列的HTML表,但由于条目太多,我希望在每个表中将该列除以3列(或除以4或5,等等)。

我该怎么做?

示例:

我有什么和我想要什么

  I have this:      I Want Something like this:
  +---------+     +--------+---------+--------+
  | Diogo   |     | Diogo  | André   | João   |
  +---------+     +--------+---------+--------+
  | André   |     | Filipe | Carlos  | Gaspar |
  +---------+     +--------+---------+--------+
  | João    |     | Fabio  | Fernado |        |
  +---------+     +--------+---------+--------+
  | Filipe  |
  +---------+
  | Carlos  |
  +---------+
  | Gaspar  |
  +---------+
  | Fabio   |
  +---------+
  | Fernado |
  +---------+

我不是php人员,但一些算法可能会有所帮助。1)获取男性/女性的记录计数

"SELECT count(*)FROM nomes WHERE nome LIKE '$_POST[letra]%' AND sexo = 'f'; ..... same for 'male'.  

将其保存到mcount和fcount变量中。

if mcount >10
then 
 noOfColms=mcount /10;
 i=0;
 put "<table>"
loop records 
i=i+1;
put "<tr>"
if(i<noOfColms)
   put "<td>" + data +"</td>"
if i==noOfColms
put "</tr>"     
end loop   
put "</table>"

其他显示列表视图

对fcount 执行相同操作