search problems?

[JamesGMills]

Problem:

Search string

$s = $_GET['s'];

could be something like

france, white

then i have

SELECT *, date_format(item_dateAdded, '%D %M %Y') as item_dateAdded FROM items WHERE 
	 item_name LIKE '$s' OR item_country LIKE '$s' OR item_type LIKE '$s' OR item_subtype LIKE '$s'

But the problem is i need to split the $s up because there is two workds to search for but this just confuses the search?

How do you do this?

Ahhhhhhhhhgggrrrrrr....

 

[DRJ478]

FIrst of all, this is more a SQL question than a PHP question.
Anyway, here are some pointers:

1. You have to decide what you want to split on - it appears it is the comma.
2. Have a look at the explode() function in the PHP manual. It will put the search arguments into an array.
3. Iterate the array with foreach() and construct the search SQL.

It might also be helpful to use the percent wildcards in the SQL to make sure that the search term found also if it is within a string, not just at the beginning.

Hope that helps.

 

[JamesGMills]

Interesting - yes thats enough to get me started on looking into the solution - thank you