Select Query with Multiple Optional Values
| From: | benc11@gmail.com | Date: | Sat, 21 Mar 2009 17:30:03 +0000 |
| Subject: | Select Query with Multiple Optional Values | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-290508@lists.php.net to get a copy of this message | ||
Trying to find best way to accomplish following scenario. Looking to search
inventory through a POST form, have the following optional fields to search
by: Product Name, Color, Size, and Status. Search maybe for the Product
Name and/or Color or they may search for just the Color or all 4 fields. I
am trying to find the most efficient way to do this without having 100
different if statements.