removing "and" & "or" from this search code..

deezzer

Hi all, this is my first post here. i was wondering if you could help my site function better by removing "and", "or", from the search query.

Here's the code:
}

/* generate query syntax for searching in auction */
$search_words = explode (" ", $qquery);

	/* query part 1 */
$qp1 = "";
$qp = "";

$qp1 .= 
	" (title LIKE '%".
	addslashes($qquery).
	"%') OR (description LIKE '%".
	addslashes($qquery)."%') ";

$qp .= " (cat_name LIKE '%".addslashes($qquery)."%') ";

$addOR = true;
while ( list(,$val) = each($search_words) )
{
	$val = ereg_replace("%","\\%",$val);
	$val = ereg_replace("_","\\_",$val);
	if ($addOR)
	{
		$qp1 .= " OR ";
		$qp .= " OR ";
	}
	$addOR = true;

	$qp1 .= 
		" (title LIKE '%".
		addslashes($val).
		"%') OR (description LIKE '%".
		addslashes($val)."%') ";

	$qp .= "(cat_name LIKE '%".addslashes($qquery)."%') ";
}

//it is possible i did not paste the correct part of the code, if so let me know.

-Dominic Son

sneakyimp

not sure what you are asking. your code is adding "or" in this line:

$qp1 .= " OR ";
$qp .= " OR ";

deezzer

Original poster here. to clarify, when you search my site, it is returning too many items because it also includes terms with the phrases: "The", and "And".

I'd like to do something to the code that will remove common words like 'the' and 'and' from the query result.

based on the code i pasted, where and what would i do?

thanks.

Dominic

sneakyimp

you should probably defined 'remove words' in an array. you can then use the array to either make a loop which removes one word at a time, or you might be able to make use of some built-in php functionality. a lot of the pattern-matching string replacement functions accept arrays as arguments.

Oersoep

Put the blacklist in a table and JOIN it in the query.