你好,我在向数据库查询结果添加编号行/序列号时遇到问题。我已经使用$number来收集实际的行数。然后我试图避免的另一个问题是:列标题的编号。
谢谢你的帮助。
<?php
$number = mysql_num_rows($query);
for ($serial = 0; $serial < $number; $serial++)
{
echo "<tr>". $serial ."</tr>";
}
for ($i = 0; $i < $number_cols; $i++)
{
echo "<th>" . mysql_field_name($query, $i) . "</th>n";
}
while ($row = mysql_fetch_row($query))
{
echo "<tr align=center>n";
for ($i = 0; $i < $number_cols; $i++)
{
echo "<td>";
if (!isset($row[$i]))
{
echo "NULL";
}
else
{
echo $row[$i];
}
echo "</td>n";
}
echo "</tr>n";
}
echo "</table>";
echo "</span>";
echo "</div>";
?>
尽我所能从您出色的代码中获得一些理智的东西。
<?php
$serial = 1;
while ($row = mysql_fetch_row($query))
{
echo "<tr align=center>n";
echo "<td>";
echo $serial++;
echo "</td>n";
foreach ($row as $value)
{
echo "<td>$value</td>n";
}
echo "</tr>n";
}