#1 zhijiangch
if(!$tab){ //所有会员上面通过一个判断生成两种类型的sql语句,都需要用到findSql,用findAll好像第二条sql执行不了,但随着数据的增加我不需要把所有数据都提取出来,比如,我只需要提取前500条即可,如何实现?
$sql = "select * from member where 1".$where;
}else{
$sql = "select a.memid,a.memname,b.money,b.addtime,b.remarks from member a,record b where a.memid = b.memid and b.comid=".$comid.$where2;
}
$tb_member = spClass("memberModel");
$res = $tb_member->spPager($page,$page_size)->findSql($sql);
2016-04-04 21:07:10