MySQL WHERE from an array

Question

I have an array with these values, 1 & 5 and I am trying to generate a mysql query to return all of these values id, I hope that makes sense, here is my code:

if(isset($filterOpts['location'])){
                        foreach($filterOpts['location'] as $row => $value){
                                $where .= " AND `rb_locations`.`locationId` = " . $value;
                        }
                }

this will return AND rb_locations.locationId = 1 AND rb_locations.locationId = 5

I am guess that AND and AND are causing my problems. how do I fix this? When I remove the 5, it returns results.

I didnt post the rest of the query because I know its not the issue :)

Any suggestions on how to fix this?

cOle2 · Accepted Answer · 2014-07-17 17:42:47Z

3

Try using the IN clause. It checks whether a value is within a set of values:

if (isset($filterOpts['location'])) {

   $locationIds = implode(',', $filterOpts['location']);

   $where .= " AND `rb_locations`.`locationId` IN (" . $locationIds . ") ";

}

edited Jul 17, 2014 at 17:42

answered Jul 17, 2014 at 17:36

cOle2

4,7741 gold badge26 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL WHERE from an array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related