How to search products on my site
| From: | virtualsoftware at gmail dot com | Date: | Tue, 09 Aug 2005 11:54:53 +0000 |
| Subject: | How to search products on my site | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-220281@lists.php.net to get a copy of this message | ||
Hi,
I have a site with some phone products. I want to search for a specific products. I use this:
SELECT product_id, product_name FROM products WHERE product_name LIKE '%$search_string%'
It works fine if the search string counts 1 word. But if the search string id counts 2 or 3 or more
words it's not working.. How can i do this kind of search. I do not want a boolean search or a
fulltext search.
Thabks for any help!