请问各位:PHP+SQL Server怎样实现分页?谢谢
为什么下面代码总显示错误?Warning: mssql_query() [function.mssql-query]: message: 第 1 行: '8' 附近有语法错误。 (severity 15) in F:\guest\index.php on line 104Warning: mssql_query() [function.mssql-query]: Query failed in F:\guest\index.php on line 104Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in F:\guest\index.php on line 105
<?php
$conn=mssql_connect("WWW-LIUWEI","","")or die("数据库链接出错!");
mssql_select_db("guest",$conn);
$pagesize=8;
$url=$_SERVER["REQUEST_URI"];
$url=parse_url($url);
$url=$url[path];
$nsql=mssql_query("select * from guest");
$num_row=mssql_num_rows($nsql);
if($_GET[page]){
$pageval=$_GET[page];
$page=($pageval-1)*$pagesize;
$page.=',';
}
if($num_row>$pagesize){
if($pageval<=1)$pageval=1;
echo "共".$num_row."条记录"."<a href=$url?page=".($pageval-1).">上一页<a href=$url?page=".($pageval+1).">下一页</a>";
}
$sql="select * from guest limit $page $pagesize";//在这行加上limit后就会产生错误
$rs=mssql_query($sql,$conn);
while($row=mssql_fetch_array($rs)){
?>
为什么下面代码总显示错误?Warning: mssql_query() [function.mssql-query]: message: 第 1 行: '8' 附近有语法错误。 (severity 15) in F:\guest\index.php on line 104Warning: mssql_query() [function.mssql-query]: Query failed in F:\guest\index.php on line 104Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in F:\guest\index.php on line 105
<?php
$conn=mssql_connect("WWW-LIUWEI","","")or die("数据库链接出错!");
mssql_select_db("guest",$conn);
$pagesize=8;
$url=$_SERVER["REQUEST_URI"];
$url=parse_url($url);
$url=$url[path];
$nsql=mssql_query("select * from guest");
$num_row=mssql_num_rows($nsql);
if($_GET[page]){
$pageval=$_GET[page];
$page=($pageval-1)*$pagesize;
$page.=',';
}
if($num_row>$pagesize){
if($pageval<=1)$pageval=1;
echo "共".$num_row."条记录"."<a href=$url?page=".($pageval-1).">上一页<a href=$url?page=".($pageval+1).">下一页</a>";
}
$sql="select * from guest limit $page $pagesize";//在这行加上limit后就会产生错误
$rs=mssql_query($sql,$conn);
while($row=mssql_fetch_array($rs)){
?>
select top $limit * from tb_guest where fd_guest_id not in(select top $start fd_guest_id from tb_guest )
$sql="select * from guest limit $page ,$pagesize";你这些在网上有很多的,你参考下就可以的,我也是刚学的!