Php+SqlServer实现分页显示

 1<html><body><table border="1">
 2<?   
 3$id=@mssql_connect("ddy","sa"," ") or die("连接不上");   
 4$db=mssql_select_db("ddy",$id);   
 5$query="select * from lr00 order by lr0012 desc";   
 6$result=mssql_query($query);   
 7if($result):   
 8if($tt==""){   
 9$nopa=0;}   
10else $nopa=$tt;   
11$gg=mssql_num_rows($result);   
12echo $gg;   
13$k=0;   
14$i=0;   
15$dd=mssql_fetch_array($result);   
16if(!$dd){echo '到底了';}   
17while($dd&&$nopa<=$gg&&$i<3){   
18if($nopa>=$gg) $nopa=$gg;   
19@mssql_data_seek($result,$nopa);   
20$dd=@mssql_fetch_array($result);   
21if($dd){$nopa++;$i++;   
22echo "<br/>";   
23echo $dd[1]; }   
24}   
25endif;   
26?&gt;</table>
27<?if($nopa<$gg){?>
28<a $nopa+1;?="" href="fenye2.php?tt=&lt;?echo">&gt;下一页</a></body></html>
Published At
Categories with Web编程
Tagged with
comments powered by Disqus