protected $_link = array(
//关联文章表
'Article'=>array(
'mapping_type' => self::HAS_MANY,
'class_name' => 'Article',
'foreign_key' => 'uid',
'mapping_fields' =>"id",
),
//关联评论表
'Comment'=>array(
'mapping_type' => self::HAS_MANY,
'class_name' => 'Comment',
'foreign_key' => 'uid',
'mapping_fields' =>"id",
),
//关联动态表
'Dynamic'=>array(
'mapping_type' => self::HAS_MANY,
'class_name' => 'Dynamic',
'foreign_key' => 'uid',
'mapping_fields' =>"id",
),
);控制类代码$id = I("GET.id");
$user = D("User");
//$where["id"] = array("in",$id);
$data = $user->relation(true)->field("id")->find($id);正常显示
当控制类代码改成
$id = I("GET.id");
$user = D("User");
$where["id"] = array("in",$id);
$data = $user->relation(true)->field("id")->where($where)->select();的时候显示就不正常了:
。关联就不正常显示了
难道是where的in条件查询与relation有冲突吗?但堆栈SQL信息查询显示正常的,头疼啊,实在不行的话,只能循环用find方法了。
最佳答案