mssql分页下一页只取到第一条数据
<?
$niandu=$_GET['niandu'];
$link=mssql_connect("MyServer2k","data","1234");
mssql_select_db("data",$link);
$sql="select id,niandu,yuefen,name,time from a where niandu='$_GET[niandu]' order by yuefen desc";
$dataset=mssql_query($sql,$link);
$totalCount=mssql_num_rows($dataset);
$P=$_GET[P];
if(!$P|| $P<1) $P=1;
$PageNum=15;
$start = $PageNum * ($P-1);
?>
<table width="750" border="0" align="center" cellpadding="0" cellspacing="1">
<tr align="center">
<td width="10%" height="20">序号</td>
<td width="10%" height="20">年度</td>
<td width="10%" height="20">月份</td>
<td width="25%" height="20">名称</td>
<td width="20%" height="20">发布时间</td>
<td width="20%" height="20">管理</td>
</tr>
<?
$sql1="select TOP ".$PageNum*($P)." id,niandu,yuefen,name,time from a where niandu='$_GET[niandu]' order by yuefen desc";
$dataset1=mssql_query($sql1,$link);
$count=mssql_num_rows($dataset1);
for ($i=$start;$i<$count;$i++){
list($id,$niandu,$yuefen,$name,$time)=mssql_fetch_row($dataset1);
?>
<tr>
<td height="20"><? echo $i+1?></td>
<td height="20"> <? echo $niandu?></td>
<td height="20"> <? echo $yuefen?></td>
<td height="20"> <? echo $name?></td>
<td height="20"> <? echo $time?></td>
</tr>
<?
}
?>
</table>
15条记录一页,不知道为什么翻到下页时总是取表的第1条记录而不是第16条,请大家帮忙看看