Need help with search engine

[eluser]Randy Casburn[/eluser]
@M4rc0 - you did fine! The only mistake you made was running the query twice. The second time you ran it, you queried every record. Check the docs. Here is the mistake:

[quote author="M4rc0" date="1222474337"]Here's my code:

Code:

QUERY 1)        $this->db->query('SELECT * FROM movies WHERE MATCH (name,director,actors,country,year,comment) AGAINST ('.$keywords.' WITH QUERY EXPANSION);');        
QUERY 2)        $query = $this->db->get('movies');

[/quote]

The only thing you should have to do to correct this is remove:

Code:

QUERY 2)        $query = $this->db->get('movies');

and then you should be able to find your results thus:

Code:

foreach ($query->result() as $row)
{
   echo $row->title;
   echo $row->actor
   echo $row->yada;
}

Hope this helps,

Randy