Select AND / OR problem

[eluser]Khoa[/eluser]
I also found that the missing of brackets cause many confusion and also makes us not feel confident about the sql statement that CI generates. I used to do a lot of sql statement writing on my own, and some of them are very very complicated. Manually writing is tedious but it helps me ensure that I put AND, OR and brackets in exactly where I want them to be.

I think there should be a function like: $this->db->openBracket() and $this->db->closeBracket() to allow user to insert them wherever they want.

xwero, your method is a way to work around this, but by doing so, I think we cannot make use of the escaping feature that CI provides (well, to be honest, I dont really know what CI does, but feel more confident whey it says it does :-D). Am i right?