Re: [PHP-DB] Help with search engine and splitting values needed :-( From: Jason G. (blair <email protected>)
Date: 10/15/01

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>