Thursday, 27 February 2014

Join 3 tables in codeigniter

Join in codeigniter

Join 3 tables by codeigniter

$query = ee()->db->select('b.id,b.rec_date,b.status,b.member_id, b.merchant_name, b.order_number, b.shipping_company, b.tracking_number,b.optional_service, b.inspected, c.first_name, c.last_name, c.mailbox_number,d.group_title as membership')
->from('exp_incoming_order b')
->order_by('b.id','desc')
->join('exp_members c', 'b.member_id=c.member_id and '.$whereCond)
->join('exp_member_groups d', 'd.group_id=c.group_id')
->limit($this->perpage, $rownum)
->get();

0 comments:

Post a Comment