Re: searching key words from a database field

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" <php-general@gremlins.com.hk> To: <php-general@lists.php.net> 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 > > /* > Keep a diary and one day it'll keep you. > -- Mae West > */ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > >