Re: Help with search engine and splitting values needed :-(

You may want to look into the MySQL FULLTEXT searches. www.mysql.com They do alot of the work for you... -Jason Garber IonZoft.com At 10:01 PM 10/14/2001 -0400, Chris Payne wrote:

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