Jump to content

T_Constant_Encapsed_String


NONAME_2

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/271776-t_constant_encapsed_string/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.