Help with search engine and splitting values needed :-(
| From: | Chris Payne | Date: | Mon, 15 Oct 2001 02:01:10 +0000 |
| Subject: | Help with search engine and splitting values needed :-( | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13309@lists.php.net to get a copy of this message | ||
Hi there everyone,
I currently have a partially written search engine for a client and it works fine using the WHERE /
LIKE settings (I'm using MySQL with the latest PHP for Windows to program). My question is
this:
Currently if you enter a single word it searches fine - if you enter afr it will bring all entries
for africa or anything similar to afr which is what I need. However, how do I make it so that if
they enter several words on the line that it searches for each word? I know it's probably
straight forward to most people, but i'm stumped.
I guess it needs to split the string from the form and then run the LIKE command on each string, but
I don't know how to split the string and then get the DB to read each one?
Any help would be sincerely appreciated - in newbie form though please :-)
Thank you.
Chris Payne
chris@planetoxygene.com
http://www.planetoxygene.com