I'm doing a search with custom fields. The problem is that when you use more than one, the search results include listings that meet either one or the other field, instead of needing to meet both of them.
for example, if I have 2 custom fields: 'Property Type' and 'Availability'
and I have the following 3 properties:
Property 1 - Property Type: House - Availability: Rent
Property 2 - Property Type: Flat - Availability: Rent
Property 3 - Property Type: Flat - Availability: Sale
now if I do a search where 'Property Type' = Flat and 'Availability' = Rent, all 3 properties will come up as search results, but only Property 2 should be coming up because it's the only one that meets both search criteria
The problem lies in how the SQL query is being made. I'll be fixing this on my end (on a tight schedule with a client here, can't wait for plugin updates), but I thought I'd let you know