关于 $this->db->or_where();

L.e.e.

where
        (A.idx_member_c_send = ".$this->session->userdata('pr_idx')." and
        A.idx_member_c_recv != ".$this->session->userdata('pr_idx')." and
        A.f_save_send = 1 and
        A.f_block = 0)
                or
        (A.idx_member_c_send != ".$this->session->userdata('pr_idx')." and
        A.idx_member_c_recv = ".$this->session->userdata('pr_idx')." and
        A.f_save_recv = 1 and
        A.f_block = 0)
        order by A.id_threads desc";


我想把这句 用 $this->db->where() , $this->db->or_where() 来表达～应该怎么写呢？ 我试过了 没发现那里出错但是 就是 SELECT的数据是 不对的～是我写错条件了 还是 不能实现 那个效果？

去年明日

你试下这样
$this->db->where(A.idx_member_c_send = ".$this->session->userdata('pr_idx')." and
        A.idx_member_c_recv != ".$this->session->userdata('pr_idx')." and
        A.f_save_send = 1 and
        A.f_block = 0);
$this->db->or_where(A.idx_member_c_send != ".$this->session->userdata('pr_idx')." and
        A.idx_member_c_recv = ".$this->session->userdata('pr_idx')." and
        A.f_save_recv = 1 and
        A.f_block = 0) ;
$this->db->order_by(A.id_threads ,"desc");

L.e.e.

去年明日 发表于 2013-6-11 14:49
你试下这样
$this->db->where(A.idx_member_c_send = ".$this->session->userdata('pr_idx')." and
       ...

我已经解决了，但是 还是谢谢你的回复 哈～～我用你说的方式 做的 可以！