Welcome Guest, Not a member yet? Register   Sign In
selecting from multiple tables
#3

[eluser]blu3ness[/eluser]
Code:
$this->db->select('a.*, b.title AS cat_title')
->from('products a')
->join('categories b','a.category_id = b.id','INNER')
->where('category_id',$category_id);
worked

Thanks TheFuzzyOne Smile


Messages In This Thread
selecting from multiple tables - by El Forum - 05-24-2009, 12:44 PM
selecting from multiple tables - by El Forum - 05-24-2009, 12:58 PM
selecting from multiple tables - by El Forum - 05-24-2009, 01:12 PM



Theme © iAndrew 2016 - Forum software by © MyBB