Transalate RAW SQL INTO CI's active record class

Transalate RAW SQL INTO CI's active record class - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Transalate RAW SQL INTO CI's active record class (/showthread.php?tid=26593)

Transalate RAW SQL INTO CI's active record class - El Forum - 01-18-2010

[eluser]sico87[/eluser]
I have this

Code:
SELECT *

FROM categoryTable

WHERE categoryId NOT

IN (

SELECT categoryId

FROM userMenuTable

WHERE cookieId = 'bang4b544417a41b6'

)

but I would like it use codeigniters active record class so using

Code:
$this->db

syntax, I was hoping someone would help me convert this?

Transalate RAW SQL INTO CI's active record class - El Forum - 01-18-2010

[eluser]flaky[/eluser]

Code:
$this->db->select('categoryId');

$this->db->where('cookieId', 'bang4b544417a41b6');

$category_list = $this->db->get('userMenuTable')->result();

$this->db->where_not_in('categoryId', $category_list);

$result = $this->db->get('categoryTable')->result_array();