Php+SqlServer实现分页显示

  •   2009-07-31/22:58
  • <html><body><table border=1>
    <?
    $id=@mssql_connect("ddy","sa"," ") or die("连接不上");
    $db=mssql_select_db("ddy",$id);
    $query="select * from lr00 order by lr0012 desc";
    $result=mssql_query($query);
    if($result):
    if($tt==""){
    $nopa=0;}
    else $nopa=$tt;
    $gg=mssql_num_rows($result);
    echo $gg;
    $k=0;
    $i=0;
    $dd=mssql_fetch_array($result);
    if(!$dd){echo '到底了';}
    while($dd&&$nopa<=$gg&&$i<3){
    if($nopa>=$gg) $nopa=$gg;
    @mssql_data_seek($result,$nopa);
    $dd=@mssql_fetch_array($result);
    if($dd){$nopa++;$i++;
    echo "<br>";
    echo $dd[1]; }
    }
    endif;
    ?></table>
    <?if($nopa<$gg){?>
    <a href=fenye2.php?tt=<?echo $nopa+1;?>>下一页</a></body></html><?}?>



    评论 {{userinfo.comments}}

    {{money}}

    {{question.question}}

    A {{question.A}}
    B {{question.B}}
    C {{question.C}}
    D {{question.D}}
    提交

    驱动号 更多