This topic is locked

Parse error....Any Ideas?

5/8/2007 6:58:26 PM
PHPRunner General questions
R
run4sbc author

I just created this file in 4.0 i think build 241 and this came up
Parse error: syntax error, unexpected T_VARIABLE in /home/run4sbc/public_html/NewYorkStateMeet/include/commonfunctions.php on line 2291

Sergey Kornilov admin 5/8/2007

Usually this caused by incorrect default value.
What's the line 2291?

R
run4sbc author 5/8/2007

$LookupSQL.="where "."EntryNote = "$SESSION["EntryNote"];
I dont see anything wrong with it....so I dont know what is wrong.
// create Lookup wizard control

function BuildSelectControl($field, $value, $values="", $secondfield=false, $mode)

{

global $conn,$LookupSQL,$strTableName,$useAJAX;

$LookupSQL ="";

$strSize = 1;

$cfieldname=GoodFieldName($field);

$cfield="value
".GoodFieldName($field);

$clookupfield="displayvalue".GoodFieldName($field);

$ctype="type".GoodFieldName($field);

if($secondfield)

{

$cfield="value1
".GoodFieldName($field);

$ctype="type1_".GoodFieldName($field);

}

if($values)

$arr=&$values;

$addnewitem=false;
$script="";

if($strTableName=="_IndividualEntries" && $field=="TeamCode")

{

$addnewitem= false ;

$LinkField="TeamCode";

$DisplayField="TeamCode";

$LookupTable="_Teams";

$strSize=1;
$LookupSQL = "select ";

$LookupSQL .= "`TeamCode`";

$LookupSQL .= ",`TeamCode`";

$LookupSQL .= ",`TeamCode`";

$LookupSQL .= " from `_Teams` ";
Line 2291 ------> $LookupSQL.="where "."EntryNote = "$_SESSION["EntryNote"];
}

if($strTableName=="_IndividualEntries" && $field=="TeamName")

{

$addnewitem= false ;

$LinkField="TeamCode";

$DisplayField="TeamName";

$LookupTable="_Teams";

$strSize=1;
$LookupSQL = "select ";

$LookupSQL .= "`TeamCode`";

$LookupSQL .= ",`TeamName`";

$LookupSQL .= " from `_Teams` ";
$LookupSQL.="where "."EntryNote = "$_SESSION["EntryNote"];
$LookupSQL.=" ORDER BY `_Teams`.`TeamName`";
}

Sergey Kornilov admin 5/8/2007

Correct line would be as follows:

$LookupSQL.="where "."EntryNote = " . $_SESSION["EntryNote"];