Simple search engine queries

[eluser]Dirk Einecke[/eluser]
Hi,

[quote author="Berik" date="1261168627"]@Dirk: If I run multiple queries how will distinct() prevent duplicates? Must be something I'm missing here! I was thinking of removing already found IDs in subsequent queries to do that.[/quote]

You don't have to make multiple queries if you want to get one results list.

You can combine all search terms in one query:

Code:

foreach ($terms as $term) {
  $this->db->or_like('db_field_to_search', $term);
}

Dirk