Trouble with search query containing multiple keywords....

pseudocool

Ok, so, I have had no problem getting my code right to search all of the columns however, It will only find the first couple words in the returned search results. What i am attempting to accomplish is what i think any search should be, the ability to type "frog dog fish" and return all or any of the results...I assume i need to explode and loop through the query however i am not sure how to go about it...this is my first php project and it is a pretty big project.... here is the code i have thus far:

if($search_q=='')
			{	
				$keywords = $_POST['keyword_q'];
				$search_q = "
				col1  Like '" . $keywords . "%' || 
				col2  Like '" . $keywords . "%' || 
				col3  Like '" . $keywords . "%' || 
				col4  Like '" . $keywords . "%' || 
 				col5  Like '" . $keywords . "%'";
			}
			$query =  mysql_query("SELECT * FROM table WHERE " . $search_q) or die(mysql_error());

Thanks in advance!

Res

It's probably a better idea to use mysql fulltext index and use the match functions in mysql to do the searching.

http://devzone.zend.com/article/1304

It's a little more robust then what you have currently. If you want to keep it how you have, you would just need to explode and loop over the keywords to build the sql as you already suspect.

$keywords = $_POST['keyword_q'];
$keywords = explode(" ", $keywords);                

$search_q = '';
foreach($keywords as $word){
   $search_q .= "col1  Like '" . $word . "%' ||";
}
$search_q = substr($search_q, 0, -2); //strip off the last ||
//...