Ajax Searc - uppercase

[pilon]

Hello,
I install the ajax search suggest it is great but i have a big problem.

The system search by the exactly word, for example, the product is "TT Lofer" if we try search by "tt lofer" nothing shows...

we have to ignore the uppercase, it is possible?

Thanks

[Alex]

Yes, you should modify the .php file where search is performed. Modify the SQL statement as you need.

[pilon]

Great how can i do that? sorry....

[pilon]

I thing the problem is here,

 'WHERE LOWER(products_name) LIKE "' . strtolower($keyword) . '%" and language_id = "'.$languages_id.'"';

[pilon]

anynone?

[mickelmore]

The problem might me also due to some missing files try to delete this and reinstall the new one.