Expanding search capability

[brooky]

Hi,

I have the following code to search the DB:

$query_count = "select * from ".$prefix."store_inventory where (description like '%$search%' or title like '%$search%')";

This is caled from a simple form there the textbox is caled search.

Does anybody know how I can make it work with search functions like:

red AND hat

green OR yellow??

Any ideas?

[leatherback]

Well,

You could of course check the search string for 'and' and 'or' accurances if(strpos($searchstring, 'and')),
explode the string into multiple sections if there is a match $newsearch = explode('and', $searchstring);
and then build your query from the pieces.

J.