More session issues... I don't get it.

[dloeppky]

Hi all,

Here we go:

If I do:
echo $SESSION["var1"]; // prints fine

$userid=$SESSION["var1"];
echo $userid; // prints fine

$strSQL = "SELECT * FROM users WHERE ID=$SESSION['var1']";
echo $strSQL // DOESN'T print the ID portion.

OR

$strSQL = "SELECT * FROM users WHERE ID=".$SESSION['var1'];
echo $strSQL // DOESN'T print the ID portion.

OR

$strSQL = "SELECT * FROM users WHERE ID=$userid";
echo $strSQL // DOESN'T print the ID portion.

OR

$strSQL = "SELECT * FROM users WHERE ID=".$userid;
echo $strSQL // DOESN'T print the ID portion.

What am I doing wrong?

Cheers,
David

[planetsim]

it should be $_SESSION['var1'];

[notionlogic]

Although you talk about using $SESSION, the earlier reply is correct in saying $SESSION (note the underscore) but... $SESSION was introduced with PHP v4.1 or v4.2 upwards (or something like that)...

I'm guessing that your configuration has register_globals switched off so have you tried:

$strSQL = "SELECT * FROM users WHERE ID=".$HTTP_SESSION_VARS["var"']";

Or have I misunderstood ????