[PHP] How to search products on my site

2005-08-09 Thread virtualsoftware
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

RE: [PHP] How to search products on my site

2005-08-09 Thread Jay Blanchard
[snip] 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

Re: [PHP] How to search products on my site

2005-08-09 Thread Miles Thompson
At 08:54 AM 8/9/2005, [EMAIL PROTECTED] wrote: 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

RE: [PHP] How to search products on my site

2005-08-09 Thread Jim Moseby
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