Operator precedence in SQL queries using DB class

[eluser]wcaicedo[/eluser]
Hi friends, i have this question: Is there a way to specify logic operator precedence in a query using those functions available in DB class? Recently i needed something like:

Code:

"SELECT * FROM table where date = $date and (id = $id or other_id = $id)"

But i didn't find a way to specify that using $this->db->or_where() and stuff.

Any ideas? or i'm missing something here..


Thanks in advance.

[eluser]Praveen A P[/eluser]
Hey did you try this out? May be the SQL related stuff needs to be done through SQL itself, CI would just send the query and get the results.

Please try this out and let us know what happens?

At least, from a JAVA perspective thats true.

[eluser]dmiden[/eluser]
Hi!

You should use the $this->db->query() function for more complexed queries, f.ex.

Code:

$sql = "SELECT * FROM table WHERE date = ? AND (id = ? OR other_id = ?)";
$this->db->query($sql, array($date, $id, $id));

Or you could use $this->db->where() as a custom string, e.g.

Code:

$this->db->where('date', $date);
$this->db->where("(id={$id} OR other_id={$id})");
$this->db->get('table');

That'd produce the same as above.

[eluser]wcaicedo[/eluser]
Thanks bud, i ended up using something like the second one as a workaround, that stays then . It would be a nice thing if CI included something to manage that precedence without resorting to one's custom queries...

Thanks a lot!

William.