Unexpected T_Constant_Encapsed_String

[NONAME_2]

hello, i have same prob.

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/../form/formOne.php on line 26

<?php
include("../header.inc.php");
require_once inc_dataAccess;
require_once '../classes/public.class.php';
require_once '../classes/First.class.php';

$RegID = $_REQUEST["RegID"];
$StNo  = $_REQUEST["StNo"];

$query = "SELECT concat(PFName,' ',PLName) as FullName,StudentSpecs.StNo,BirthLoc,BirthDate,NID,DadName,
   persons.PersonID,concat(rel," ",subRel) as  Religion,MarStatus, Address2,PhoneNo,mobile,
   PEduSecName,PFldName,ShiftName
   FROM FirstInterview
   left join StudentSpecs using(StNo)
   left join persons on(StudentSpecs.PersonID=persons.PersonID)
   left join EducationalSections using(EduSecCode)
   left join StudyFields using(FldCode)
   left join StudyStatus using(StatusID)
  left join (select DomainValue,description as Rel from domains where DomainName='RELIGION') tmp1 on(tmp1.DomainValue=persons.Religion)
   left join (select DomainValue,description as subRel from domains where DomainName='SUB_RELIGION') tmp2 on(tmp2.DomainValue=persons.SubReligion)
   left join (select DomainValue,description as MarStatus from domains where DomainName='MARITAL_STATUS') tmp3
   on (tmp3.DomainValue=persons.MaritalStatus)
   left join (select DomainValue,description as ShiftName from domains where DomainName='SHIFT') tmp4 on(tmp4.DomainValue=StudentSpecs.shift)
   where  StudentSpecs.StNo =". $StNo ." and FirstInterview.RegID =" . $RegID ;
$temp = dataAccess::RUNQUERY($query)->GetRows();
$tbl_content = "";

there is a place in $query

[kicken]

$query = "SELECT concat(PFName,' ',PLName) as FullName,StudentSpecs.StNo,BirthLoc,BirthDate,NID,DadName,
   persons.PersonID,concat(rel," ",subRel) as  Religion,MarStatus, Address2,PhoneNo,mobile,

 

You need to escape the quotes in concat(rel," ",subRel) or change them to be single quotes.

 

[NONAME_2]

thank you very much

Edited December 10, 2012 by NONAME_2