[Resolved] fulltext search '+ operator' question!

lizzyd

greetings!

I'm trying to make a search box for my hotel search site using the mysql fulltext search facility.

when someone types in, say, "tennis golf" (without the quotation marks) i'd like it to bring up a list of hotels which offer BOTH tennis AND golf facilities.

when i query my database with the following it works perfectly:

SELECT Hotel_Id FROM hotel WHERE MATCH (Town,DescriptionEnglish) AGAINST ('+tennis +golf' IN BOOLEAN MODE)

However, when i try to translate this to PHP i'm having problems. Can anyone tell me where i'm going wrong with this?


$query = "SELECT Hotel_Id FROM hotel WHERE MATCH (Town,DescriptionEnglish) AGAINST ('+(" . ($_POST['keywords']) . ")' IN BOOLEAN MODE)";

I just can't seem to get the + symbol to apply to everything that appears inside the brackets.

Any ideas would be much appreciated!

Cheers!

LizzyD

LarsLai

hi!
I just can think of one possibility now (but there might be others...).
after retrieving the keywords, add a + to every keyword,
so there will be no need of brackets anymore.

lizzyd

Thanks LarsLai, I would but I don't know how to do it! Would appreciate any ideas or if anyone could point me to a tutorial!

LizzyD

LarsLai

something like this:

$keywords = $_POST['keywords'];
// add + to the first keyword
$keywords = '+' . $keywords;
// replace ' ' with ' +' so you add a + to every keyword
$keywords = str_replace(' ', ' +', $keywords);

lizzyd

aha!!! thanks LarsLai - you're a genius!

sorry for being so thick - i should have been thinking a bit more inventively!

Cheers for your help - i really appreciate it!

LizzyD