Hmm to do a search on one table it might actually be quicker to do a query
for every thing in the query.  First convert to all lowercase.  Then explode
the query into an array using " " as the delimiter.  Then implode this array
into a list that looks something like this.  "var1","var2"...)  you can do
this by using implode and putting Quotes at the end.  Then in the query you
can use the IN part of the query.  I'm sorry if this is totally incorrect
but I'm going off my memory.  SELECT fields FROM tbl
                                    WHERE tblFields IN ($query)  it might be
INTO but I'm dang sure it is IN.  Go to Zend.com and phpbuilder.com for some
good resources on search engines you can modify it to suit your needs.  I
this helps a little bit.

    -Mike
----- Original Message -----
From: "Chris Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 30, 2002 7:15 PM
Subject: [PHP-DB] Database search question


Hi there everyone,

How can I accomplish the following?

I have a table called search,

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 know I need to splitup my search phrase into individual words to search,
but i'm stuck.

Thanks for any help.

Chris



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

Reply via email to