On Sat, May 21, 2005 1:35 pm, virtualsoftware@xxxxxxxxx said: > 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 You can use http://php.net/strlen to determine if the user has typed anything into any given INPUT. Or, if you want a "simple" search with only one INPUT, something like: $query = "select product_id from products where 1 = 0 "; $words = explode(' ', $input); while (list(, $word) = each($words)){ $query .= " or title like '%$word%' "; $query .= " or description like '%$word%' "; . . . } -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php