Advance software forum
May 18, 2012, 08:46:00 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Ajax Searc - uppercase  (Read 684 times)
0 Members and 2 Guests are viewing this topic.
pilon
Newbie
*
Offline Offline

Posts: 4


View Profile
« on: March 24, 2011, 06:42:17 AM »

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
Logged
Alex
Administrator
Full Member
*****
Offline Offline

Posts: 128


View Profile
« Reply #1 on: March 24, 2011, 07:01:19 AM »

Yes, you should modify the .php file where search is performed. Modify the SQL statement as you need.
Logged
pilon
Newbie
*
Offline Offline

Posts: 4


View Profile
« Reply #2 on: March 24, 2011, 09:41:53 AM »

Great how can i do that? sorry....
Logged
pilon
Newbie
*
Offline Offline

Posts: 4


View Profile
« Reply #3 on: March 24, 2011, 01:01:46 PM »

I thing the problem is here,

 'WHERE LOWER(products_name) LIKE "' . strtolower($keyword) . '%" and language_id = "'.$languages_id.'"';
Logged
pilon
Newbie
*
Offline Offline

Posts: 4


View Profile
« Reply #4 on: March 28, 2011, 04:26:46 AM »

anynone?
Logged
mickelmore
Newbie
*
Offline Offline

Posts: 1


View Profile
« Reply #5 on: January 16, 2012, 01:57:35 AM »

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

Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 3.1.1 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!