PHP Varibles Help

[hewstone999]

I have a problem is passing the values accoss in the SQL in the PHP code below. The $z varible will get a value from the session, the $z value will then be used in the SQL. However the value dose get passed across to the SQL code.

 

 

<?

$db_conn = new COM("ADODB.Connection");

$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./Database1.mdb").";";

$db_conn->open($connstr);

$z = $_SESSION['user'];

$MySql = "SELECT * FROM users_details WHERE user_id = (SELECT users_id FROM users_login WHERE Username = '$z')";

$rs = $db_conn->Execute($MySql);

 

while(!$rs->EOF){

$user_id = $rs->Fields("user_id")->value;

$surname = $rs->Fields("surname")->value;

$forname = $rs->Fields("forname")->value;

$DOB = $rs->Fields("DOB")->value;

$gender = $rs->Fields("gender")->value;

$email= $rs->Fields("email")->value;

 

$rs->MoveNext();

 

?>

 

Any ideas how i can passed the value across, or is there another meathod of doing this?

 

Thanks in advance for your help.

[ober]

What version of mysql are you using?  MySQL doesn't support subqueries until version 5.

[lonewolf217]

i dont see a session_start() anywhere

 

you have to initialize a session before you can use it