[eluser]Developer13[/eluser]
Somebody please help me out here... my brain is just fried on this issue!
Let's say I want to generate the following query via CI's active record:
SELECT * FROM table WHERE last_name = 'Terry' AND (first_name = 'Alex' OR first_name = 'Jesse')
How in the world do I indicate that I want the AND and the OR separated by parenthesis?
Of course the actual query is much larger and more involved than the example and I'd like to stick with CI's active record if possible.
Any ideas would be greatly appreciated!