Hi, I need to build up a search module for a shop. If I make a basic search (product title for example) it is ok.
$query = "SELECT product_id FROM products WHERE title LIKE '%$title%'"; But i need an advance search for more than one field (title, description, price, weight) The problem is that i don't know which field is filled in by the user (title, description, price or weight) I mean, the user can fill in all fields, or only price field, or title and weight etc How can i do the search? Thanks
