2. PHPRunner General questions
  3. Session variable in SQL Statement
This topic is locked

Session variable in SQL Statement

 		1/6/2009 8:04:00 AM
PHPRunner General questions
U
 Urnso author

[codebox]if ($_SESSION["UserID"])

$strWhereClause = whereAdd($strWhereClause,"Name like ".$_SESSION["UserID"]);[/codebox]
This is giving me an unknown column error? am I missing some ' (singlequotes) somewhere?
J
 		Jane 1/6/2009

Hi,
please see my changes in Bold:

if ($_SESSION["UserID"])

$strWhereClause = whereAdd($strWhereClause,"Name like '".$_SESSION["UserID"]."'");