Need help with search engine

[eluser]M4rc0[/eluser]
Hi!

I'm trying to implement a search in my CI app using mysql's fulltext index and searching

I think it's a very good way to perform a search in website (can't rely on google custom search so far as this is a localhost website), if anybody has another approach, please tell me! I'd be interested to hear.

So once i make this work i think it's good to have the code documented here in the forum if anybody looks for this (I didn't find anything like it in the forum).

So far is not working :-P

Here's my code:

Code:

function search_movie()
     {
         //SELECT * FROM table WHERE MATCH (field1,field2) AGAINST ('keyword' WITH QUERY EXPANSION);*/
        $keywords = "'".$this->input->post('keywords')."'";        
        $this->db->query('SELECT * FROM movies WHERE MATCH (name,director,actors,country,year,comment) AGAINST ('.$keywords.' WITH QUERY EXPANSION);');        
        $query = $this->db->get('movies');
        return $query->result();
     }

The sql is performing correctly, already did an echo to see the output of the query.

But it's showing all rows i have in the table instead of just those containing the keywords.

Anybody has any clue where the problem might be?