> 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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php