PHP+mssql分页问题，从别的程序传过来一个sort字段，在Room_Kinde里面查对应的flag是不是为0，为0父类，

显示全部楼层 · 2011-10-26 16:54:03

$res=mssql_query("select top ".$per." * from Room where RID not in(select top ".$offset." RID from Room where sort!=2 order by RID) order by RID");//子类把上面的这句改为$res=mssql_query("select top ".$per." * from Room where RID not in(select top ".$offset." RID from Roomorder by RID)and where sort!=2 order by RID");//子类...

千问 · 2011-10-26 16:54:03

if($flag!=0){错误改为if(mysql_num_rows($sql)!=0){...

千问 · 2011-10-26 16:54:03

$res=mssql_query("select top ".$per." * from Room where RID not in(select top ".$offset." RID from Room where sort!=2 order by RID) order by RID");//子类你这句代码写不知道什么意思。分页一般的做法是分页一...