CiviCRM Community Forums (archive)

Hi all,

I am creating a custom search and I keep on getting a syntax error in the following $select variable. I know it has to do with the fact that the select I am inserting in it is escaping it and breaking into a new string or something like that. I am not familiar with how PHP works when building these types of variables.

The error thrown is "Parse error: syntax error, unexpected T_STRING in xxxxxxx, line 110". Line 110 is the line with the bold "(SELECT DISTINCT". I tested this SQL statement in my SQL Query editor and it worked like a charm.

        // SELECT clause must include contact_id as an alias for civicrm_contact.id

        $select  = "
DISTINCT (cOrg.ID) as contact_id, (cOrg.sort_name) AS Team, (cOrg.nick_name) AS Flight,
(cRT.name_b_a) as Role, (cInd.display_name) as Name, (cPh.Phone) AS Phone,
[b](SELECT DISTINCT[/b] (cPh2.Phone) FROM civicrm_phone cPh2 where cPh2.contact_id = cInd.id and cPh2.Phone_Type = "Mobile") AS Mobile,
(SELECT DISTINCT (cPh3.Phone) FROM civicrm_phone cPh3 where cPh3.contact_id = cInd.id and cPh3.Phone_Type = "Fax") AS Fax
";

Any help is appreciated.

thanks,
Jose

That fixed it. Thanks Lobo.