query help

viveleroi0

I use the following code to seperate two words from a search, then make an sql query string to search the fields accordingly. It works great with one word, but when more than word is used, everything happens fine except the "AND" sections is never added. I just get "field1 like $word field1 like $word"
It nevers knows when to put the "and" conjunstion in there. Why?

$method = array(0=>" OR ", 1=>" AND ");
$words = split(" +",addslashes($searchwords));
$query = "select * from test where ";
$once=0;
foreach($words as $word){
if ($once) $query.=$method[$andor];
$query.= "field1 like '%$word%'";
$once=1;
}
print $query;

jburfield

I don't see a value for o$andor here? Do you set it elsewhere?

-- Jason

viveleroi0

Thats what I was thinking, No, it snot set anywhere. but what do I set it as?

jburfield

I do it something like this:

$words = split(" +",addslashes($searchwords));
/* GET TOTAL NUMBER OF WORDS */
$total_words = count($words);
$query = "select * from test where ";
$query .= "field1 like \"%" . $words[0] . "%\" ";
for($x=1;$x<$total_words;$x++)
{
/* THIS COULD BE 'AND' IF YOU WANTED TO HAVE FIELD 1 CONTAIN ALL OF THE WORDS */
$query .= "OR field1 like \"%" . $words[$x] . "%\" ";
}

Basically, it adds the first word to the query (you should add a test to make sure there is at least one) and then loops through the rest adding the 'OR' in the front of that particular section of the query.

-- Jason