Welcome Guest, Not a member yet? Register   Sign In
[question - solved] Join - active record
#5

[eluser]wemago[/eluser]
ok...and again...DUH... lol
i really need a sleep.

for those who need an answer for this,
this is what i did and works Smile

Code:
$this->db->select('lab_users.username,lab_articles_categories.category_title, lab_articles.*');
        $this->db->join('users', 'articles.author_id = users.user_id');
        $this->db->join('articles_categories', 'articles.category_id = articles_categories.category_id');
        $this->db->orderby('article_id', 'asc');
        $this->db->groupby('lab_articles.article_id');
        $this->db->offset($offset);
        $this->db->limit($num);
        
        return $this->db->get('articles');


Messages In This Thread
[question - solved] Join - active record - by El Forum - 08-07-2007, 03:16 PM
[question - solved] Join - active record - by El Forum - 08-07-2007, 04:07 PM
[question - solved] Join - active record - by El Forum - 08-07-2007, 04:16 PM
[question - solved] Join - active record - by El Forum - 08-07-2007, 04:36 PM
[question - solved] Join - active record - by El Forum - 08-07-2007, 06:23 PM
[question - solved] Join - active record - by El Forum - 08-08-2007, 12:16 AM



Theme © iAndrew 2016 - Forum software by © MyBB