this is my mysql query
SELECT MAX(A.BID),B.*
FROM tbl_bid A
INNER
JOIN wl_customers B
ON A.customers_id=B.customers_id
WHERE portfolio_id='$Id'
how to write this query in codeigniter.
this is my mysql query
SELECT MAX(A.BID),B.*
FROM tbl_bid A
INNER
JOIN wl_customers B
ON A.customers_id=B.customers_id
WHERE portfolio_id='$Id'
how to write this query in codeigniter.
Something like
$this->db->select('MAX(A.BID),B.*')
->join('wl_customers as B','A.customers_id=B.customers_id')
->where('portfolio_id',$Id)
->get('tbl_bid as A')
->row();