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