G'day Chris

> I have 3 fields, city, country, type
> I also have an imput box where you can type in a search word.  What I need is,
> say you type in hotels germany, I need the search to break up the sentence and
> then search each 3 fields in the DB looking for a match.
> So, for example: it would find hotels in type and germany in country, see that
> they belong together and then display those results - how can I do this?

I'm far from an expert but what you're describing sounds like a classic use
of the Match command and a multi-column full text index in mysql. Of course
I don't know if you're using mysql.

cheers

kim


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to