"Syntax error" when using Zend_Db to query MySQL database

Question

This is my query:

$query = $db
    ->select()
    ->from(array('ns' => 'news_subscriber'),
        array('ns.id', 'ns.subscriber_email')
    )
    ->where('ns.id NOT IN (?)', 
        $db
            ->select()
            ->from(array('nss' => 'news_subscribers_has_news_letter_content'),
                array('nss.news_subscribers_id')
            )
            ->where('nss.news_letter_content_id =' , $id)
    );
$subscribers = $db->fetchAll($query);

I am getting this error:

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 '))))' at line 1`

I feel the problem is in the "IN".

Any ideas?

I have fixed your formatting in this post for you this time, but please review stackoverflow.com/editing-help when posting questions in future. — Treffynnon
– Treffynnon, Commented Apr 28, 2011 at 8:38

demonkoryu · Accepted Answer · 2011-04-28 08:56:42Z

4

Your query has multiple errors.

->where('nss.news_letter_content_id =', $id)

You forgot the ? after the =.
->where('ns.id NOT IN (?)', $db->select() ...

I'm pretty sure that you have to convert the subquery object to an array first.

edited Apr 28, 2011 at 8:56

answered Apr 28, 2011 at 8:46

demonkoryu

1,26711 silver badges27 bronze badges

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

Comments

Karthik · Accepted Answer · 2011-04-28 08:43:53Z

2

$subscribers = $db->fetchAll($db->select()->from('news_subscriber ns, subscriber_email se')
->where('ns.id NOT IN ('.$db->select()->from( 'news_subscribers_has_news_letter_content nss') ->where('nss.news_letter_content_id =',$id))));

I dont use array in my select. See if this is helpful.

answered Apr 28, 2011 at 8:43

Karthik

1,0911 gold badge13 silver badges36 bronze badges

Comments

Chandresh M · Accepted Answer · 2011-04-28 08:45:25Z

1

you may write your query like this..please check below.

$subscribers = $db->fetchAll($db->select()->from(array('ns' => 'news_subscriber','nss'=> 'news_subscribers_has_news_letter_content'),
                                array('ns.id',
                                    'ns.subscriber_email','nss.news_subscribers_id'))                
                ->where('ns.id NOT IN (?) AND 'nss.news_letter_content_id =',$id);

Thanks.

answered Apr 28, 2011 at 8:45

Chandresh M

3,4932 gold badges27 silver badges48 bronze badges

Comments

Tomáš Fejfar · Accepted Answer · 2011-04-28 10:57:47Z

1

Note that you can always see the whole query to see where is the problem.

echo (string)$query;
// die();

answered Apr 28, 2011 at 10:57

Tomáš Fejfar

11.2k8 gold badges58 silver badges85 bronze badges

Comments

koool · Accepted Answer · 2011-04-28 08:42:58Z

0

are you sure that all the variables that you have used in your query are getting a value, most of the times this error occurs if the values of the variables in the query are uninitialized or "" in case of a string ......... Also in this case I think you have an extra ')' in the end hope that helps

answered Apr 28, 2011 at 8:42

koool

15.6k11 gold badges47 silver badges60 bronze badges

1 Comment

haider Over a year ago

yeap i just checked them one by one

Collectives™ on Stack Overflow

"Syntax error" when using Zend_Db to query MySQL database

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related