thinkphp多表查询的问题，求帮助
php codepublic function graduate(){ $this->checklogin();//判断登录 $graduate=m('graduate'); $category=$_get['category']; $map['flg']='0'; $map['lan']='01'; import(@.org.page); $count = $graduate->join('left outer join person on(graduate.personid=person.personid andperson.flg='.$flg.')')->where($map)->count(); $p = new page ($count, 10 ); $list=$graduate->limit($p->firstrow.','.$p->listrows)->join('left outer join person on graduate.personid=person.personid and person.flg=0')->where($map)->order('graduate.graduateid desc')->findall(); $page = $p->show (); $pagenumber=$p->nowpage; $this->assign (pagenumber, $pagenumber-1 ); $this->assign (page, $page ); $this->assign (list, $list ); $this->display(); }
graduate表的personid是person表的外键，join后查不到值，哪个大侠帮看看什么问题？
还有，这东西分大小写么？
ps：不会php，但是boss让买个bug。。。
------解决方案--------------------
$list=$graduate->limit($p->firstrow.','.$p->listrows)->join('left outer join person on graduate.personid=person.personid and person.flg=0')->where($map)->order('graduate.graduateid desc')->findall();
后面：
echo $graduate->getlastsql();
看下最后sql执行语句是什么，是否sql有错误