Problem with a query

[Robust]

        $groupPairs = $this->_getDb()->fetchPairs('
        SELECT group_id, group_name
        FROM apms2_group
        WHERE group_id IN (?)
        ', $groups);

This returns the first pair only.

$groups is '1,2'

If I replace IN (?) with IN (1,2) (for testing) it works properly and fetches multiple pairs. But if I use a prepared statement ($groups is also 1,2) it returns the first value only.

I've tried Zend_Debug::dump to ensure $groups is correct, it is.

Also doesn't work with:

WHERE group_id IN (' . $this->_getDb()->quote($groups) . ')

 

[SneakyDave]

I had a similar problem with prepared statements a while back. I think this page helped me figure it out.

http://stackoverflow.com/questions/...how-do-i-use-each-one-in-a-mysql-query-in-php

 

[Mike]

$groups is '1,2'

You need to split this to turn it into an array and then use the quote() method you gave as your final example.

 

[Robust]

You need to split this to turn it into an array and then use the quote() method you gave as your final example.

Thanks Mike. I'll try that out.