求php+mssql分页实例

  <title>php+mssql分页</title>  
  </head>  
  <?php  
   
  //数据查询模块  
   
  //服务器总数  
  $count_chat_sql   =   "select   count(gas_ip)   as   count   from   t_game_gas   with   (nolock)";  
  $count_result       =   mssql_query($count_chat_sql,$my_conn);  
  $count_row             =   mssql_fetch_array($count_result);  
  $count                     =   $count_row['count'];  
   
  //分页模块  
  $pagex =   $_GET['page']?$_GET['page']:1;   //当前页面的页 ***  
  $per_page =   20; //每页显示数量  
  $pages             =   ceil($count/$per_page);//总页数  
  $forward         =   $_GET['forward']?$_GET['forward']:0;  
  $gas_ip =   urlencode($_GET['offset']);  
   
  //具体数量查询  
  if   ($forward   ==   0){  
  $user_count_sql   =   "select   top   20   gas_ip,sum(user_counts)   as   counts   from   t_game_gas   with(nolock)   group   by   gas_ip   order   by   gas_ip";  
  }else   if   ($forward   ==   1){  
  $user_count_sql   =   "select   top   20   gas_ip,sum(user_counts)   as   counts   from   t_game_gas   with(nolock)   where   gas_id>$gas_ip   group   by   gas_ip   order   by   gas_ip";  
  }else   if   ($forward   ==   2){  
  $user_count_sql   =   "select   *   from   (   select   top   20   gas_ip,sum(user_counts)   as   counts   from   t_game_gas   with(nolock)   where   gas_id<$gas_ip   group   by   gas_ip   order   by   gas_ip   )   t   order   by   t.gas_ip";  
  }else   {  
  $user_count_sql   =   "select   *   from   (   select   top   20   gas_ip,sum(user_counts)   as   counts   from   t_game_gas   with(nolock)   group   by   gas_ip   order   by   gas_ip   )   t   order   by   t.gas_ip";  
  }  
   
  $user_count_result   =   mssql_query($user_count_sql,$my_conn);  

论坛热门帖子:	[lch203] 写得蛮好的linux学习笔记(10-21) [黑马制造] 学习java的30个目标(10-19) [笑傲股林] 做测试半年了，有点迷茫，应该再学些什么提高自己的测试水平和测试能力呢？(10-19) [udp8589] 大家用google的来吱一声? 用百度的~~也来报道下?(10-18) [沂偌掳兆] 本人总结的一些认为C++比较经典的书籍，希望对大家有用(10-18)
TAG标签:	实例 // if gas_ip else page function limit echo href