[Resolved] [Resolved] [Resolved] Searching a mysql db

saracen

Hi,

Im trying to create a php search function that will query a mysql db but with boolean "And" "or" "And NOT" functionality. Is this possible?

Using the code below, I am able to bring up data that is searched for by creating a FULLTEXT index for the required fields but I dont know how to limit that data e.g. where the user wants criteria a and b or a and not b:

$result = mysql_query("SELECT a, b,c,d,e,f FROM table WHERE match(a, b,c,d,e,f) against ('%$search%')");
if (!$result) {
die('Error performing query: ' . mysql_error() .
'');
}

while ( $row = mysql_fetch_array($result, MYSQL_ASSOC) ) {
echo('
' . $row["a"] . '
' . $row['b'] . '
' . $row['c'] . '
' . $row['d'] . '
--------------------------
');
}

saracen

Hmm, is the question too stupid or too complicated?

leatherback

Hi,

possible, but complicated to propgram:

Do a search on this in the forum, there was a post exacty like this about a week ago. That person decided not to do it:

Different options:

say terms: a, b, c, d

interprete:

((a and b) or c) or d
a and b or c and d
a and ((b or c) and d)
a and (b or (c and d))

Of course you can write a script to work this. But be willing to take a lot of time for nesting and splitting etcetc.

saracen

Thanks for the reply Leatherback, I was worried that was going to be the answer.

mtimdog

It would be easier to give the user a choice (all of the terms, any of the terms, exact phrase) and you could also have a textbox for terms not to include.

Then, depending on which one the user chooses, use a switch statement to make the query.

saracen

Good idea mtimdog, wish I'd read ur reply sooner. However, I solved it using the str_replace method. Seems to work so far.