phql issue

Question

phql issue

Rakesh Nov '14

Created Nov '14	Last Reply Nov '16	Replies 5	Views 1191	Votes 0

Rakesh 8.7k

Nov '14

Code:

$query = $this->modelsManager->createQuery("SELECT id,first_name,last_name,contact_email from Contacts where flag=1 UNION ALL SELECT id,first_name,last_name,bounce_email_address from MailchimpImportContacts where flag=1");
$contacts = $query->execute();**

Hello Friends When I used above query getting error such as :

Syntax error, unexpected token IDENTIFIER(UNION), near to ' ALL SELECT id,first_name,last_name,bounce_email_address from MailchimpImportContacts where flag=1', when parsing: SELECT id,first_name,last_name,contact_email from Contacts where flag=1 UNION ALL SELECT id,first_name,last_name,bounce_email_address from MailchimpImportContacts where flag=1 (175)

How to resolve it

Thien Tran · Answer 1 · 2014-11-04T02:41:50-07:00

Hey

This is code below working in phpmyadmin yet ?

SELECT id,firstname,lastname,contact_email from Contacts where flag=1 UNION ALL SELECT id,first_name,lastname,bounceemail_address from MailchimpImportContacts where flag=1

Rakesh · Answer 2 · 2014-11-04T02:48:34-07:00

Hey

This is code below working in phpmyadmin yet ?

SELECT id,firstname,lastname,contact_email from Contacts where flag=1 UNION ALL SELECT id,first_name,lastname,bounceemail_address from MailchimpImportContacts where flag=1

Yes I know but not working in phalcon when I try to execute.

Thien Tran · Answer 3 · 2014-11-04T03:27:00-07:00

Thien Tran
58.4k

Nov '14

I think sql query not correct https://www.w3schools.com/sql/sql_union.asp

Rakesh · Answer 4 · 2014-11-04T03:47:19-07:00

Syntax error, unexpected token IDENTIFIER(UNION), near to ' SELECT id,first_name,last_name,bounce_email_address from MailchimpImportContacts where flag=1', when parsing: SELECT id,first_name,last_name,contact_email from Contacts where flag=1 UNION SELECT id,first_name,last_name,bounce_email_address from MailchimpImportContacts where flag=1 (196)