Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Search problem


Guest

Recommended Posts

Please help. I've having trouble with the seach function.

 

Here's my page: (Try searching both with 'Jacket' and 'Jackets')

 

http://www.kohalaplantation.com/order/adva...keywords=jacket

 

If you search on 'jacket,' you get results, if you search on 'jackets', nothing is returned.

 

I've looked at the code and it appears that it's being queried using "LIKE", so why isn't it return for close matches?? It's being too literal.

 

Anyone have any ideas or suggestions? :'(

Link to comment
Share on other sites

Please help.  I've having trouble with the seach function. 

 

Here's my page: (Try searching both with 'Jacket' and 'Jackets')

 

http://www.kohalaplantation.com/order/adva...keywords=jacket

 

If you search on 'jacket,' you get results, if you search on 'jackets', nothing is returned.

 

I've looked at the code and it appears that it's being queried using "LIKE", so why isn't it return for close matches??  It's being too literal. 

 

Anyone have any ideas or suggestions?  :'(

 

 

LIKE means teh product has the word you typed in or the word you typed in is part of the product text.

 

Meaning:

if your product is jackets and you type in jacket, it will be found

if your product is jacket and you type in jackets, no match

 

By the way, there is a contrib cutting of the s at the end of search strings for just this purpose. Or you could use singular forms for product names :-).

 

Monika

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...