query DB with array

Anon

I am passing an array from a HTML form into a PHP script. I am then imploading it.

if ($propType)
{
$prop = implode($propType, ",");
}

I am thing trying to run $prop through the query which has several vars that it is searching on.

AND (propType LIKE '%$prop%' OR '$propType' = ' ')

I would like for the db just to match part of the string and not all of it. Right now it is needing an exact match of the string passed. What am I doing wrong?

In a nutshell, I think I need to replace LIKE in the query with something not so sensitive, more of a OR, and not so much a AND. Hopefully that makes since. Let me know if you have any questions. Thanks for help!

Anon

I'm not sure what your propType field looks like, but this may help:

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Functions

Look at the one that says
"expr IN (value,...)"

Diego

joeywoodbury

it is coming from four checkboxes

Anon

I meant the database field propType...

Anyway, you never told me if the IN() function was useful...

Diego

joeywoodbury

I am still getting no results from the multi search when I have more then one item in the array. The propType field is a varchar(16) with only text in it. I run a print statment to print $prop after using implode and it gives me this "Residential,Multifamily" for having two of the boxes checked. And this for one box checked "Residential"

It has results for the one boxes, but not the multi select.

this is how the query looks now:
AND (propType IN ('$prop') OR '$propType' = ' ')

I think the IN might be the right direction though. So thanks for the help so far.