[eluser]Dannymx[/eluser]
Well, the problem is that I'm getting different results when changing the AGAINST parameter.
When I use a word as the parameter I get the correct result I want, but when I use a variable that contains that word I get nothing.
Code that works as expected:
Code:
$this->db->select('titulo, autor, editorial, id');
$this->db->where('MATCH (titulo, autor, editorial) AGAINST ("dummies" IN BOOLEAN MODE)', NULL, FALSE);
$busqueda_libros = $this->db->get('libros');
And I get nothing when doing this:
Code:
$titulo = 'dummies';
this->db->select('titulo, autor, editorial, id');
$this->db->where('MATCH (titulo, autor, editorial) AGAINST ("$titulo" IN BOOLEAN MODE)', NULL, FALSE);
$busqueda_libros = $this->db->get('libros');
As you can see the only change was the AGAINST parameter now using a variable.
The fields are already set in fulltext.
Maybe I am missing something, but I tried almost everything.
Edit: Also I want to know if is possible to use more than one parameter in AGAINST, like 2 or 3 variables.