Issues with results page and field named state
I'm getting an error in my search results page: Column 'state' in where clause is ambiguous. I have a field named state in each tqable, but I have renamed one of them in the query, but the error is not going away. I am attaching my page of code.