Welcome Guest, Not a member yet? Register   Sign In
Trying to add parentheses im Active Record Query
#2

[eluser]Armchair Samurai[/eluser]
Something like:

Code:
$search = $this->db->escape_like_str('book');
$sql = <<<ENDSQL
(games.gameName_en LIKE '%$search%'
OR games.gameName_es LIKE '%$search%'
OR game_platform.keywords LIKE '%$search%')
ENDSQL;


$this->db->where('galleries.galleryShow', 'y');
$this->db->where('galleries.galleryType', 'video');
$this->db->where($sql, NULL, FALSE);


Messages In This Thread
Trying to add parentheses im Active Record Query - by El Forum - 05-13-2010, 05:31 PM
Trying to add parentheses im Active Record Query - by El Forum - 05-14-2010, 01:58 AM



Theme © iAndrew 2016 - Forum software by © MyBB