Magento：过滤getCollection不起作用

Question

My getCollection code is providing the wrong query string (i think).

I have a table called banner which I can load all records from easy enough. When I try to filter it I'm getting errors.

Here is the code:

$banner = Mage::getModel('banner/banner')->getCollection()->addFieldToFilter('group', array('eq'=>'search_group'));

The page crashes and I get this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group = 'search_group')' at line 1";i:1;s

As you can see it seems like the code is messing up the quotes after group.

'group = 'search_group')'

Can anyone advice on how to fix this?

Thanks,

Billy

Answer 1

group is an SQL keyword. If group is also an attribute name you'll need to escape it somehow. Try using backticks (the typically unused key below <kbd>Esc</kbd>).

$banner = Mage::getModel('banner/banner')
    ->getCollection()
    ->addFieldToFilter('`group`', 'search_group');