Exclude keyword from search results

Re: [waterdancer] Exclude keyword from search results

By Jason - August 23, 2011

Hi,

If you could fill out a [url http://www.interactivetools.com/support]2nd Level Support Request[/url] I can take a quick look and see what's going on.

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [waterdancer] Exclude keyword from search results

By Jason - August 23, 2011

Hi,

I took a look and I think I found the problem. Since the Miele is only part of the name, and not the entire name, we need to use the MySQL LIKE function. I changed the query to this:

list($productsRecords, $productsMetaData) = getRecords(array(
'tableName' => 'products',
'perPage' => '10',
'where' => "name NOT LIKE 'miele%'",
));


This seems to be working now.

Hope this helps,
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/