_keyword search

Hi,

Creating a completely intelligent search like you're suggesting, especially the "quality of match" part can be tricky. This won't completely do it, but it should get your closer.

The idea is to break up each word of your search and search for it separately. In this example, we're assuming the field we're searching on is called title, the section is called news (these can be changed), and we've dropped _keyword from the end of our variable:

$where = "";
$allowSearch = true;

if (@$_REQUEST['title']) {

$separatedWords = array_filter(explode(" ", @$_REQUEST['title']));

if($separatedWords) {

foreach ($separatedWords as $word) {
$where .= "title LIKE '%".mysql_escape($word)."%' OR ";
}

$where = rtrim($where, " OR ");
$allowSearch = false;
}


}

list($newsRecords,$newsMetaData)=getRecords(array(
'tableName' => 'news',
'allowSearch' => $allowSearch,
'where' => $where,

));

So, in this code, if we find "title" in our URL, we break up the search into separated words separated by a space. We then look for each word separately.

The one draw back here is that it doesn't distinguish between words. For example, if you search for "Art and Design", it will return any record that has "art", "and", or "design" in it's title.

Hope this helps get you started.