mssql_query("set names utf-8");
$page=$_GET['p'];
if(!isset($page)){//当前页默认为1
$page = 1;
}
$pageNumber = 10;
$startCount = ($page-1)*$pageNumber;
$res=mssql_query("select top $pageNumber * from UserAccounts where ID not in(select top $startCount ID from UserAccounts where MemberOrder!=20 order by Gametime desc,UserID desc) and MemberOrder!=20 order by Gametime desc,UserID desc");
$i=0;
while ($result=mssql_fetch_assoc($res)){
$list[$i]=$result;
$i++;
}
这些是代码