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.
