<table width="880" border= "1" style= "border-collapse: collapse" bordercolor= "#000000" align="center" >
<tr>
<td width="30" height="33" bgcolor="#FFFFFF"><div align="center">选</div></td>
<td width="60" bgcolor="#FFFFFF"><div align="center">户号</div></td>
<td width="60" bgcolor="#FFFFFF"><div align="center">姓名</div></td> <td width="" bgcolor="#FFFFFF"><div align="center">备注</div></td>
<td width="80" bgcolor="#FFFFFF"><div align="center">楼(幢)户</div></td>
<td width="80" bgcolor="#FFFFFF"><div align="center">本户人数</div></td>
<td width="80" bgcolor="#FFFFFF"><div align="center">打印预览</div></td> </tr>
<?php
$pagesize=200;
if ($total<=$pagesize){
$pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==""){
$page=1;
}else{
$page=intval($_GET[page]);
}
$sql1=mysql_query("select * from ccccc where M='户主' order by K asc limit ".($page-1)*$pagesize.",$pagesize",$conn);
while($info1=mysql_fetch_array($sql1))
{
?>
<tr bgcolor="#ffffff" onMouseOver="this.bgColor='#ccccccc';" onMouseOut="this.bgColor='#ffffff';">
<td height="21" ><div align="center">
<input type="checkbox" name="<?php echo $info1[addtime];?>" value=<?php echo $info1[id];?>>
</div></td>
<td ><div align="center"><?php echo $info1[K];?></div></td>
<td ><div align="center"><?php echo $info1[F];?></div></td> <td ><div align="center"></div></td>
<td ><div align="center"><?php echo $info1[P];?></div></td>
<td ><div align="center"><?php
$KK=$info1[K];
$sql4=mysql_query("select count(*) as total from ccccc where K='$KK' order by K asc",$conn);
$info4=mysql_fetch_array($sql4);
$total4=$info4[total];
echo $total4;?></div></td>
<td ><div align="center">
<a href="ziyuan_so.php?name=<?php echo $info1[K];?>" target="_blank">
<img src="images/print_16x16.gif" width="16" height="16" alt="打印预览" border="0"></a></div></td>
</tr>
<?php
}
?>
</table>
以上代码,使用while循环读出数据后 每列超出10个数据后换列怎么写,最好给上面代码改一下,加上注释,谢谢各位了。
这里不是有循环么
你外面建个变量 $i=1然后while每次循环 ++i;
if($i %10 ==0)
{
换行
}
<table width="880" border= "1" style= "border-collapse: collapse" bordercolor= "#000000" align="center" >
<tr>
<td width="30" height="33" bgcolor="#FFFFFF"><div align="center">选</div></td>
<td width="60" bgcolor="#FFFFFF"><div align="center">户号</div></td>
<td width="60" bgcolor="#FFFFFF"><div align="center">姓名</div></td> <td width="" bgcolor="#FFFFFF"><div align="center">备注</div></td>
<td width="80" bgcolor="#FFFFFF"><div align="center">楼(幢)户</div></td>
<td width="80" bgcolor="#FFFFFF"><div align="center">本户人数</div></td>
<td width="80" bgcolor="#FFFFFF"><div align="center">打印预览</div></td> </tr>
<?php
$pagesize=200;
if ($total<=$pagesize){
$pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==""){
$page=1;
}else{
$page=intval($_GET[page]);
}
$sql1=mysql_query("select * from ccccc where M='户主' order by K asc limit ".($page-1)*$pagesize.",$pagesize",$conn);
while($info1=mysql_fetch_array($sql1))
{
$i++;
if($i % 10 == 0){
echo "</tr>";
} //判断一下是否是10的倍数,如果是的话,换行
?>
<tr bgcolor="#ffffff" onMouseOver="this.bgColor='#ccccccc';" onMouseOut="this.bgColor='#ffffff';">
<td height="21" ><div align="center">
<input type="checkbox" name="<?php echo $info1[addtime];?>" value=<?php echo $info1[id];?>>
</div></td>
<td ><div align="center"><?php echo $info1[K];?></div></td>
<td ><div align="center"><?php echo $info1[F];?></div></td> <td ><div align="center"></div></td>
<td ><div align="center"><?php echo $info1[P];?></div></td>
<td ><div align="center"><?php
$KK=$info1[K];
$sql4=mysql_query("select count(*) as total from ccccc where K='$KK' order by K asc",$conn);
$info4=mysql_fetch_array($sql4);
$total4=$info4[total];
echo $total4;?></div></td>
<td ><div align="center">
<a href="ziyuan_so.php?name=<?php echo $info1[K];?>" target="_blank">
<img src="images/print_16x16.gif" width="16" height="16" alt="打印预览" border="0"></a></div></td>
<?php
}
?>
</table>
再者我不知道,你所谓的换行是什么意思,因为每个tr结束后,它便会换行!而上面添加的那个判断,如果刚好是10的倍数,则所有标签刚好匹配,如果不是10的倍数的话,最后可能少一个tr的结束标签,建议你最好不要这样判断