Help with search engine and splitting values needed :-(

From: 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

« previous php.db (#13309) next »