query help

[joeywoodbury]

I have four vars: $resi, $multi, $land, $comm

I have a query and part of it looks like this: AND (propType LIKE ('%$resi%') OR propType LIKE ('%$multi%') OR propType LIKE ('%$land%') OR propType LIKE ('%$comm%') OR '$propType' = ' ')

I am wanting it to query the database on the idea that the propType field can be LIKE any of the vars and return a row. It searches okay with one var. But when I search on more than one var it gives me no results. It is looking in the field for Residental, Multifamily. When the field will only contain one of the vars.

Its like it is having to match all of the vars in that one field, when each field will only contain one of the vars. Hope this makes since. Any help would be appreciated.

[Anon]

Do you have a fifth variable called $propType, because you are using it instead of propType after the last OR.

[joeywoodbury]

No I don't, that is what the array was named. I then implode it to a string and the spilt it into four varibles. I changed it but it still isn't working.

[Anon]

Post the rest of the query, there must be something wrong somewhere else. What you have should work.