Session PROBLEM...**URGENT**

[l_fhoenix_l]

Hi there,
thanks for your attention.

I wanna know if it is possible to use a variable that is out of SESSIONS with db. for example:

I have a session called 'user' and i use it 2 keep the user data. can i use it to do a SELECT...FROM...WHERE... to find the other info of 'user'

bye

[nunomira]

hi,

something like:

$myVar = $_SESSION['myVar'];

$query = "SELECT FROM myTable var1, var2, ... WHERE var0 = '$myVar'";

or, maybe this is ok too... but more confusing

$query = "SELECT FROM myTable var1, var2, ... WHERE var0 = '$_SESSION["myVar"]'";

[mtimdog]

Originally posted by nunomira

or, maybe this is ok too... but more confusing

$query = "SELECT FROM myTable var1, var2, ... WHERE var0 = '$_SESSION["myVar"]'";

[/B]

unfortunately, you cannot use quotes inside of an sql query but it can be written a few ways

//if myVar holds the data...
$query = "SELECT FROM myTable var1, var2, ... WHERE var0 = '$_SESSION[myVar]'";

//or another way to use an array
$query = "SELECT FROM myTable var1, var2, ... WHERE var0 = '{$_SESSION['myVar']['id']}'";
//or another way to use an array
$query = "SELECT FROM myTable var1, var2, ... WHERE var0 = '". $_SESSION['myVar']."'";

[nunomira]

yes, I thought so...
but after some tries for having the board write $_SESSION[\'myVar\'], which I think is ok, I quit... and left the double quotes...
sorry for that
😉