multiple keywords search problem

[queryguy]

$terms = explode(" ", $_GET["items"]);
$query = "SELECT * FROM warehouse WHERE";
$numterms = count($terms);
for($b = 0; $b < $numterms; $b++) {
$terms[$b] = trim($terms[$b]);
if($b > 0) {
$query .= &quot; OR&quot;;
}
$query .= &quot; items LIKE '%&quot; . $terms[$b] . &quot;%'&quot;;
$query .= &quot; and listid LIKE '%&quot; . $listid . &quot;%'&quot;;
$query .=&quot; and listed LIKE '1'&quot;;
$query .=&quot; order by active desc, listed desc&quot;;
$results=mysql_query($query) ;

}


This code is for searching my database with multiple keywords, but it only can enter one key word at a time for searching, if enter 2 keywords it will return no results. Anyone here can tell me how to solve this problem?

 

[sleipnir214]

If you print $query at the point before you hand it's value to mysql_query(), what does it look like?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

If you change the line:

$results=mysql_query($query) ;

To read:

$results=mysql_query($query) or die(mysql_error());


what do you get as output?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[queryguy]

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR items LIKE '%%' and listid LIKE '%1%' and listed LIKE '1

this is all it displayed

 

[queryguy]

this error will only occurs when I entered 2 keywords to search, with one keyword, it display results without problems.

 

[queryguy]

Any helps?

 

[DRJ478]

Tip:
print the entire SQL statement that is created. First with 1 term, then with more. Let's see the output.
(I suspect your OR structure is malformed. It should be in parenthesis etc.)