Problems with LIKE statement

[paulbradley]

I have a search box which users can enter a phrase and it searches for items LIKE what they enetered, using the following command:

SELECT product_name FROM products WHERE product_name LIKE '$searchitem' ORDER BY end_time

But this only seems to return items identical to product_name. Any ideas? Thanks in advance.

 

[nego78]

change it to

SELECT product_name FROM products WHERE product_name LIKE '%$searchitem%' ORDER BY end_time

gry online

 

[paulbradley]

No luck I'm afraid - just the same result.

Thanks for your help so far.

 

[paulbradley]

Oooops, sorry - it does work, many thanks!