ack! query failed:
  • errorno=1064
  • error=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 'AND fwcc_sections.`Country Name` = projects.`Country Name` AND (Status = 'Displa' at line 34
  • query=SELECT `Organisation Name` as OrgName, `Contact Name` as ContactName, `Building Name` as Addr1, `Street Address` as Addr2, `Locality` as Addr3, `Post Town` as Town, `State/Co/Prov` as State, `Postal Code` as Zip, `Business Phone` as Phone, `US toll free number` as TFPhone, `Email` as Email, `Website` as Web, projects.`Country Name` as Country, Date_Format(`Date of Info`,'%M %Y') as InfoDate, `Territory` as Territory, `Project Supporting Agency` as Agency, DATE_FORMAT(`Project Start Date`,'%M %Y') as SDate, DATE_FORMAT(`Project End Date`,'%M %Y') as EDate, TO_DAYS(`Project End Date`) - TO_DAYS(NOW()) as DaysLeft, `Project Volunteer Skills Needed` as Skills, `Project Volunteer Skills-Other` as SkillsText, `Project Donations Needed` as Donations, `Project Description` as Descrip, `Project Type` as Type, `Project Volunteers Needed` as Vols, `Project Staff Vacancy` as Vacancy, `Project Expertise Offered` as Expertise, `Project Budget` as Budget, `Project Report` as Report, `Project Photo` as Photo, `FWCC Section` as Section FROM ( projects, fwcc_sections ) WHERE projects.id = AND fwcc_sections.`Country Name` = projects.`Country Name` AND (Status = 'Display')