php多行多列分页？

Question

<?php
 $p=-2;
 require_once("comm/mydb.php");
 $con=$db->connect();
 $sql="select * from live_juyuan ";
 $rs=$db->query($sql);
 $page=$_REQUEST["page"];//取得当前页数
 if(empty($page)){
     $page=1;
            }
 $n=ceil($db->nums($rs)/2);//总行数
 .........
?>
<table width="380" height="152" border="0" cellpadding="0" cellspacing="0">
    <?
  for($i=0;$i<$n;$i++){
  $p=$p+2;
?>
     <tr>
        <?
  $sqll="select * from live_juyuan limit $p,2";
  $rs=$db->query($sqll);
          while($arr=$db->nr($rs)){
?>
        <td width="400" valign="top">
  <table width="380">
     <tr>
    <td width="144" height="145" align="center" valign="top"><p><a href="bofang/bofang.php?pid=<?=$arr["id"]?>"><img src="<?=$arr["tupianpath"]?>"  border="0" alt="我要观看" /></a><a href="bofang/bofang.php?pid=<?=$arr["id"]?>"><br>
          <span class="STYLE7"><br>
      在线</span></a><span class="STYLE7"><a href="bofang/bofang.php?pid=<?=$arr["id"]?>">观看</a></span></p>
        </td>
<td width="244" valign="top">
 <table width="100%" border="0" cellspacing="0" cellpadding="0" style="font-size:12px">                 
                          <tr>
                            <td height="20"><?=$arr["title"]?></td>
                          </tr>
                          <tr>
                            <td height="20">地区：
<?
  switch($arr["guojia"]){
                         case 1: echo "内地";break;
                         case 2: echo "香港";break;
                         case 3: echo "台湾"; break;
                         case 4: echo "日本";break;
                         case 5: echo "韩国";break;
 case 6: echo "美国";break;
                         case 7: echo "英国"; break;
                         case 8: echo "法国";break;
                         case 9: echo "德国";break;
 case 10: echo "泰国";break;
                         case 11: echo "印度" ;break;
 case 12: echo "意大利";break;
 case 13: echo "西班牙";break;
                         case 14: echo "其他" ;break;
  default: 
     echo "不详";
                            }
?>
</td>
                          </tr>
                          <tr>
                            <td height="20">导演：<?
 switch($arr["daoyan"]){
                         case 1: echo "冯小刚";break;
                         case 2: echo "周星驰";break;
                         case 3: echo "陈凯歌"; break;
                         case 4: echo "张艺谋";break;
                         case 5: echo "斯嘉丽";break;
 case 6: echo "吴宇森";break;
                         case 7: echo "王家卫"; break;
                         case 8: echo "陈可辛";break;
                         case 9: echo "顾长卫";break;
 case 10: echo "詹妮弗";break;
                         case 11: echo "其他" ;break;
     default: 
     echo "不详";
                            }?></td>
                          </tr>
                          <tr>
                            <td height="20">类型：<?
  switch($arr["leixing"]){
                         case 1: echo "动作";break;
                         case 2: echo "喜剧";break;
                         case 3: echo "爱情"; break;
                         case 4: echo "科幻";break;
                         case 5: echo "恐怖";break;
 case 6: echo "记录";break;
                         case 7: echo "罪案"; break;
                         case 8: echo "战争";break;
                         case 9: echo "动画";break;
 case 10: echo "剧情";break;
                         case 11: echo "冒险" ;break;
 case 12: echo "惊险";break;
 case 13: echo "历史";break;
                         case 14: echo "西部"; break;
                         case 15: echo "黑色";break;
                         case 16: echo "悬念";break;
 case 17: echo "幻想";break;
                         case 18: echo "音乐" ;break;
 case 5: echo "歌舞";break;
 case 6: echo "家庭";break;
                         case 7: echo "传记"; break;
                         case 8: echo "其他";break;
default: 
     echo "不详";
                            }?></td>
                          </tr>
                          <tr>
                            <td height="20">上映时间：<?=$arr["sydate"]?></td>
                          </tr>
                          <tr>
                            <td height="20">播放时长：<?=$arr["time1"]?></td>
                          </tr>
                        </table></td>
 </tr>
  </table>
    </td>
          <?
    }
  ?>
     </tr>   
             <?
    }
 ?>
    </table>
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
             <tr>
               <td width="86%" height="27" bgcolor="#82C4FF">
    <a href="?page=1">首页</a> 
    <a href="#">上一页</a> 
    <a href="#">下一页</a>
    <a href="#">尾页 </a></td>
               <td width="11%" bgcolor="#82C4FF"><a href="#">更多&gt;&gt;</a></td>
               <td width="3%" bgcolor="#82C4FF">&nbsp;</td>
             </tr>
           </table>如果我在实现这样的多行两列分页效果，怎么实现呀？

Answer 1

在行里面增加一个for语句，用两个FOR语句就可以了
for ($i=$str;$i<$end;) {
  echo "<tr>\n";
  for ($j=0;$j<3;$j++) {
    echo "<td>\n".$i."</td>";
    $i++;
    if ($i=$end){break;}
  }
}

Answer 2

代码太多了，在SQL语句后加limit 起始行，行数 是不是需要这个