Same google search

[alirezaok]

hello

i have an input form for serach in database.
i want when user inputed 2 or more words with space it serach each word without near other word or near and showes both

expamle: google serach

SELECT * FROM $D1 WHERE (book LIKE '$T1%');

when i use this command and when user inputed :
store shop
it shows only where shop and shop with together and "shop" is next to "store"
and it don't showes where store and shop are not near.

this text:
example: they are store tree street shop
in my table but it not showes

what do i do for create same google search?

[ShawnK]

Try this:

$words = explode(" ", $_POST['input'] );

That will create an array named $words and in that it will have all of the words seperatly.

Then you would probaly have to do:

foreach($words as $theword){
/*
 * You would put the search thing here...and whenever you need
 * the word they put in just do: echo($theword); 
 */
}

Each word will have to be searched seperatly when you split it up...but if you just put the search inside of the foreach function then it will do whatever you put, for every word.

I don't know how you have your forms setup so I can't help anymore than that...if you post the rest of your code maybe I can help more.