Find all not working with AND

[Bman900 (Balint2005)]

So here is my code in question:

$notifications = Notifications::model()->findAll('content_author=' . $id . ' AND read =0');

Now to me the SQL looks fine yet its throwing me the following error:

CDbCommand failed to execute the SQL statement: 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 ‘read = 0’ at line 1. The SQL statement executed was: SELECT * FROM tbl_notifications t WHERE content_author = 1 AND read = 0

What is going wrong in this statement?

[highwind (Jarek571)]

Hi,

read is MySQL reserved word, you can read about it here

[weavora (Yury Tolochko)]

Wrap ‘read’ by `:

$notifications = Notifications::model()->findAll('content_author=' . $id . ' AND `read` =0');

OR add table prefix:

$notifications = Notifications::model()->findAll('content_author=' . $id . ' AND t.read =0');

OR both :

$notifications = Notifications::model()->findAll('content_author=' . $id . ' AND `t`.`read` =0');

[phtamas]

OR:

$notifications = Notifications::model()->findAllByAttributes(array(

  'content_author' => $id,

  'read' => 0

));

and let the framework take care of the rest.

[Bman900 (Balint2005)]

Thank you very much everyone!