searching key words from a database field
| From: | Philip J. Newman | Date: | Thu, 14 Feb 2002 08:38:12 +0000 |
| Subject: | searching key words from a database field | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-84707@lists.php.net to get a copy of this message | ||
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"
can anyone help?
Philip J. Newman
Philip's Domain - Internet Project.
http://www.philipsdomain.com/
info@philipsdomain.com
Phone: +64 25 6144012