DB Lib: active record: HOW TO "WHERE NOT EXISTS"

[eluser]Otemu[/eluser]
Hi,

Try something like this:

Code:

$this->db->where('NOT EXISTS (//your query)', '', FALSE);

$this->db->select() accepts an optional second parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks. This is useful if you need a compound select statement.

$this->db->select('(SELECT SUM(payments.amount) FROM payments WHERE payments.invoice_id=4') AS amount_paid', FALSE);
$query = $this->db->get('mytable');

Active record doesn't allow you to do sub-queries, there are some workarounds or libraries if you Google. If it giving you to much hassle just use normal mySQL to do this query, although active record can be quite handy there many times you end up wasting time for hardly any benefit.