In article <000801c1b5b0$ee66f180$0401a8c0@philip>, [EMAIL PROTECTED] says... > This works for the loop. now spliting up the words. now it searchs for > just one word in the loop > > any suggestions on this > > > ----- Original Message ----- > From: "Jason Wong" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, February 14, 2002 9:51 PM > Subject: Re: [PHP] searching key words from a database field > > > > On Thursday 14 February 2002 16:38, Philip J. Newman wrote: > > > I'm trying to make a search engine for my database of links. I have > been > > > using the following. > > > > > > SELECT * FROM `hyperlinks` WHERE 1 AND `keywords` LIKE '%$getme%' ORDER > BY > > > `id` ASC LIMIT 0, 30 > > > > > > if $getme = big trees > > > > > > then it would only search for key words that are there same "big trees" > not > > > for " big and trees" > > > > > > Split up your keywords. Loop through each one to construct something like: > > > > SELECT * FROM `hyperlinks` WHERE 1 > > AND `keywords` LIKE '%big%' > > AND `keywords` LIKE '%trees%' > > ORDER BY `id` ASC LIMIT 0, 30 > > > > > > This will only match when ALL the specified keywords are present. To match > on > > any one of the keywords construct something like: > > > > > > SELECT * FROM `hyperlinks` > > WHERE `keywords` LIKE '%big%' > > OR `keywords` LIKE '%trees%' > > ORDER BY `id` ASC LIMIT 0, 30 > > > > > > -- > > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
I don't quite understand what you are asking here? You are using explode or something to break the input string into separate words, and then using the list of words to build your query? Perhaps showing your problem code might be useful. -- David Robley Temporary Kiwi! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php