Question

Hello i有这种结合,但i wanna会加入另一个称为“用户”的标签,并且希望“渗透——稳定”的浏览量,如何做到:

i 是指“WHERE论坛_traad.brugernavn = 用户.profil_billed”类似的东西。

function posts($id)
{
    $this->db->select( *,forum_traad.indhold as traad_indhold,
                       forum_kommentare.indhold as kommentare_indhold,
                        forum_traad.brugernavn as traad_brugernavn,
                        forum_traad.id as traad_id
                        );
    $this->db->from( forum_traad );
    $this->db->join( forum_kommentare ,  forum_kommentare.fk_forum_traad ,  forum_traad.id );
    $this->db->where( forum_traad.id , $id);

    $query = $this->db->get();

    if($query->num_rows > 0)
    {
        return $query->row();
    } else {
        return false;
    }

}

Answer 1

你可以提出以下意见:

    $this->db->select( *,forum_traad.indhold as traad_indhold,
                       forum_kommentare.indhold as kommentare_indhold,
                        forum_traad.brugernavn as traad_brugernavn,
                        forum_traad.id as traad_id, users.profil_billed as billed
                        );
   $this->db->from( forum_traad );
   $this->db->join( forum_kommentare ,  forum_kommentare.fk_forum_traad = forum_traad.id );
   $this->db->join( users ,  forum_traad.brugernavn = users.profil_billed );
   $this->db->where( forum_traad.id , $id);
   $query = $this->db->get();

s子的详细文件如下:

rel=“nofollow” http://codeigniter.com/user_guide/database/active_record.html

友情链接