2. PHPRunner General questions
  3. What do do at PHP errors?
This topic is locked

What do do at PHP errors?

 		10/9/2007 8:54:51 AM
PHPRunner General questions
G
 glhkok author

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\SecondServerDocumentRoot\ZW\CMS\include\commonfunctions.php on line 2161
at least at entering the login.php
J
 		Jane 10/9/2007

Hi,
please post line 2161 of include/commonfunctions.php here.
G
 		glhkok author 10/9/2007

Hi,

please post line 2161 of include/commonfunctions.php here.



$lookup_SQL .= " FROM `bezetting_ruimtes` ";

$lookup_SQL.="where (".Id > 1.") AND `Id`=".make_db_value($field,$value)."";

$lookup_SQL.= " ORDER BY `naam_kort`";

}
the part:

Id > 1

is a additional WHERE entered at the lookup wizzard
J
 		Jane 10/10/2007

Hi,
here is the correct where statement:

"Id > 1"
G
 		glhkok author 10/10/2007

Hi,

here is the correct where statement:


Thanks, it works
But why is this situation different from the "ORDER BY on the list page" on the SQL query pages?
Alexey admin 10/11/2007

Gert,
this is made so to allow using PHP expressions in WHERE clause.

I.e.

"username='".$_SESSION["UserID"]."'"



There is no such a need in Order By clause.