Always Searching

i want serach in table that has one field (field name: lname)
my problem is some of words in database are not same other words!
exmpale

some records of my table are:

book shop
printer
bookshop
newspaper

now i want if an user input "book shop" or "bookshop" the script can these results:
book shop
bookshop

a way I remove all spaces from input and remove all space in filed when query:

$T1 = str_replace(" ","",$T1);
$Query = "SELECT * FROM $D1 WHERE ((str_replace(" ","",lname) LIKE '%$T1%')

but (str_replace(" ","",lname) in query line didnot work

what should i do?

what should i do?

You should read up on SQL and PHP.

You can't place a PHP function inside an SQL query and expect results.

You can achieve your intention by using a SQL function...
Insted of str_replace() (PHP)
Use REPLACE () (SQL)

$Query = "SELECT * FROM $D1 WHERE REPLACE(lname, ' ', '') LIKE '%$T1%'";