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

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 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 words

[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 word