2. PHPRunner General questions
  3. [SOLVED]  Masterkey Error
This topic is locked
[SOLVED]

 Masterkey Error

 		2/10/2011 14:30:40
PHPRunner General questions
bbarker author

Both of these work good:

$query = "SELECT VendorID, MAX(Year) FROM tableA

WHERE (VendorID = 31607)";


print_r ($_SESSION["tableA"."_masterkey1"]);


This does not:

$query = "SELECT VendorID, MAX(Year) FROM tableA

WHERE VendorID = ($_SESSION["tableA"."_masterkey1"]);



I get this ERROR:

...Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING...
Can anybody see an obvious problem?
Sergey Kornilov admin 2/10/2011

Bill,
try this:

$query = "SELECT VendorID, MAX(Year) FROM tableA WHERE VendorID = ". $_SESSION["tableA_masterkey1"];
bbarker author 2/11/2011
$query = "SELECT VendorID, MAX(Year) FROM tableA WHERE VendorID = ". $_SESSION["tableA_masterkey1"];


Yep, that did it. Many Thanks!!!