$good = M("goods");
import("ORG.Util.Page");
$count = $good->count();
$Page = new Page($count,20);
$show = $Page->show();
$rs = $good->join("think_category as tc ON think_goods.cgFid=tc.cgId")->join("think_category as tc1 ON think_goods.cgSid=tc1.cgId") ->limit($Page->firstRow.','.$Page->listRows)->select();
$this->assign("rs",$rs);
$this->assign("show",$show);
$this->display();
查询出的结果集只是和category左外连接一次的,这是为什么?
最佳答案