CI的AR如何写子查询?

longjianghu

比如下面的SQL语句:

PHP复制代码

select uid,username from cdb_member where uid=(select pid from cdb_relation where uid=1 order by pid desc limit 1)

复制代码

haohailuo

CI的AR不支持，直接用sql语句吧，如

PHP复制代码

 
$sql = "";
$this->db->query($sql);
 

复制代码

的形式就可以的

visvoy

->db->select('uid,username');
->db->where('uid','(select pid from cdb_relation where uid=1 order by pid desc limit 1)',false);
->db->get('cdb_member');

longjianghu

->db->select('uid,username');
->db->where('uid','(select pid from cdb_relation where uid=1 order by  ...
visvoy 发表于 2010-6-30 12:22

   试试,谢谢!

soareyou

->db->where('uid in (select pid from cdb_relation where uid=1 order by pid desc limit 1)',null,false);
完美解决

rainbyte

唉.AR我又让觉得鸡肋了.既然混杂了纯sql,不如直接就用sql吧.