NONAME_2 Posted December 9, 2012 Share Posted December 9, 2012 (edited) Hello, i have this error: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/../session/form/formOne.php on line 26 and this is my code: <?php include("../header.inc.php"); require_once inc_dataAccess; require_once '../classes/public.class.php'; require_once '../classes/FirstInterview.class.php'; $RegID = $_REQUEST["RegID"]; $StNo = $_REQUEST["StNo"]; $query = "SELECT concat(PFName,' ',PLName) as FullName,total_avg(StudentSpecs.StNo) as avg, total_passed_units(StudentSpecs.StNo) as pssunit,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 = ""; bytheway, total_passed_units and total_avg are tow routins in mysql; tnx. Edited December 9, 2012 by NONAME_2 Quote Link to comment https://forums.phpfreaks.com/topic/271776-t_constant_encapsed_string/ Share on other sites More sharing options...
kicken Posted December 9, 2012 Share Posted December 9, 2012 You've already been given the answer to this question. Read your threads. Quote Link to comment https://forums.phpfreaks.com/topic/271776-t_constant_encapsed_string/#findComment-1398335 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.