[PHP-DB] Help with search engine and splitting values needed :-( From: Chris Payne (chris <email protected>)
Date: 10/14/01

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 <email protected>
http://www.planetoxygene.com