Zend framework: DbTable help

PHP
1

I’ve been googling with no success. This is in Zend frameworks DbTable function.


class Model_DbTable_Meta extends Zend_Db_Table_Abstract
{
	protected $_name = 'options';
	
	public function getMetaKeywords()
	{
		$metaKeywords = 'metaKeywords';
		$row = $this->fetchRow('option = ' . $metaKeywords);
		if (!$row) {
			throw new Exception("Count not find meta data in options table.");
		}
		return $row->toArray();
	}
}


Message: SQLSTATE[42000]: Syntax error or access violation: 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 'option = metaKeywords) LIMIT 1' at line 1

I can run a successful query without the where statement. And there is a mysterious ) bracket in the new where statement at shown in the error. Any ideas?

2

option is a reserved word. :wink:

3

Oh wow, so simple and I should have known this. Had I started with another query I would have recognized the problem when I got to this one.

Thanks for the help.