<?php
$perNumber=6; //每页显示的记录数
$page=$_GET['page']; //获得当前的页面值
$count=mysql_query("select count(*) from pic where zhuangtai=0"); //获得记录总数

$rs=mysql_fetch_array($count); 
$totalNumber=$rs[0];
$totalPage=ceil($totalNumber/$perNumber); //计算出总页数
if (!isset($page)){
 $page=1;
} //如果没有值,则赋值1
$startCount=($page-1)*$perNumber; //分页开始,根据此方法计算出开始的记录
$sql="select id,title,bookpic,zhuangtai from pic where zhuangtai=0  limit $startCount,$perNumber";
$result=mysql_query($sql);

while ($row=mysql_fetch_object($result))
{
?>

            <table width="229" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="219" align="left" class="hj"><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
                  <tr>
                    <td bgcolor="#FFFFFF"><img src="<?php echo "$row->bookpic";?>" width="212" height="137" /></td>
                  </tr>
                </table></td>
                <td width="10" align="left" class="hj">&nbsp;</td>
              </tr>
              <tr>
                <td align="center" class="hj"><?php echo "$row->title";?></td>
                <td align="left" class="hj">&nbsp;</td>
              </tr>
          </table>
  <?php
  }
  ?>
  
            <p>
            <div class="jogger"><span class="disabled">
 < </span><span class="current"><?php echo "总共".$totalPage."页,";?>|<a href="anli.php?page=1">首页</a>|
  <?php
if ($page!=1) { //页数不等于1

?>
<a href="anli.php?page=<?php echo $page-1;?>">上一页</a>
<?php }?>
 
 <?php
 
 if ($page<$totalPage) { //如果page小于总页数,显示下一页链接
 ?>
 <a href="anli.php?page=<?php echo $page+1;?>">"下一页</a>
 <?php
 }
 ?>
循环出来是一个TALBE 一个图片,怎样让它循环出来 是2排  ,一排3个图片 这样排列的!!!

解决方案 »

  1.   

    加个ul li,用css就控制了。或:
    <table><tr>
    <?php
    $i=0;
    while ($row=mysql_fetch_object($result)){
    $i++;
    ?>
                <td>
                <table width="229" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="219" align="left" class="hj"><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
                      <tr>
                        <td bgcolor="#FFFFFF"><img src="<?php echo "$row->bookpic";?>" width="212" height="137" /></td>
                      </tr>
                    </table></td>
                    <td width="10" align="left" class="hj">&nbsp;</td>
                  </tr>
                  <tr>
                    <td align="center" class="hj"><?php echo "$row->title";?></td>
                    <td align="left" class="hj">&nbsp;</td>
                  </tr>
              </table></td>
    <?php
    if($i%3==0)echo "</tr><tr>";
    }
    ?>
    </tr>
    </table>