[eluser]OverZealous[/eluser] @bEz
You can mix and match some of the CodeIgniter AR methods with DMZ. Just build the items like this:
Code:
$object->where('field', $value);
// AR method
$object->db->join(...);
$object->get();
Because DMZ usually calls the built-in AR methods, they will work together. You can even use DMZ query grouping (group_start/group_end) with AR methods! The only AR methods that won't work correctly (off the top of my head) are the AR versions of LIKE.
UPDATE: er... I'm wrong about one thing. You cannot use the DMZ group methods with AR methods. I forgot that I had to hack in some intelligence for query grouping. Sorry!
But, you can use the DMZ version of LIKE directly, as well as:
• where
• select
• select_(max|min|avg)
• like
• etc.
DMZ is fairly intelligent about when to add the table name and when not to.