//实现分页模块
//每页显示的记录数
$gPageSize=15;
$query = "select * from news_news order by ID DESC";
//执行查询语句
$rresult = mssql_query($query) or die("无法执行SQL:$query");
select top $limit .....
是从开始记录读取 $limit 条记录,
怎样实现从中间记录读取呢?
根据页数计算$LimitEndNum
select top $Limit * from (select top $Limit * from (select top $LimitEndNum * from table order by id desc) a order by id asc) b order by id desc
根据页数计算$LimitEndNum
select top $Limit * from (select top $Limit * from (select top $LimitEndNum * from table order by id desc) a order by id asc) b order by id desc