Welcome Guest, Not a member yet? Register   Sign In
Query Builder Class
#1

Can someone please explain the following code related to the query builder class?
$this->db->select('(SELECT SUM(payments.amount) FROM payments WHERE payments.invoice_id=4) AS amount_paid', FALSE);

$query = $this->db->get('mytable');
Reply
#2

That is selecting a subquery results as a column called "amount_paid".

Not overly sure what you're asking.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB