Anyone have any idea what the following select will not work. I am accepting the variable $search from a search form and the doing a select with that variable. Cept, it returns nothing. I really like the my phpmyadmin runs a search, but not sure how ot do that.

Anyway, here is the code. Please let me know what you think.

By the way, why aren't I using FULLTEXT? My users search for things like cd and I am on MySQL 3.23 on a virtual box. Upgrade and configuration not possible.

Thanks

PHP Code:
$result $db->query ('SELECT products.name, products.description_short, products.map, products.id AS pid 
FROM products 
WHERE products.name LIKE %'
.$search.'% 
OR products.description_short LIKE "%'
.$search.'%" 
OR products.description_long LIKE "%'
.$search.'%" 
OR brands.name LIKE %'
.$search.'% 
OR category.name LIKE "%'
.$search.'%" 
OR deals.title LIKE "%'
.$search.'%" 
OR deals.description LIKE "%'
.$search.'%" 
OR reviews.title LIKE "%'
.$search.'%" 
OR reviews.review LIKE "%'
.$search.'%"');