using the like command works great with one word. But I did a search for using multiple words to search with and found a post on this board that had:
$text = ' ';
$the_array = explode(' ', $formdata);
$i = 0;
foreach( $the_array AS $t ){
if( $i == 0 ){
$text .= " '%$t%' ";
$i = 1;
}else{
$text .= " OR field LIKE '%$t%' ";}}
but when the query searches using the $text variable, NO results show up. Although they do using one of the same words and single "like" search. What did I do wrong?
