RE: [PHP] Search problem
| From: | Jim Moseby | Date: | Mon, 23 May 2005 15:34:42 +0000 |
| Subject: | RE: [PHP] Search problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-215752@lists.php.net to get a copy of this message | ||
> 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
$query = "SELECT product_id FROM products WHERE title LIKE
'%$title%' and description LIKE '%$description%' and price like
'%$price%'
and weight like '%weight%'";
JM