hewstone999 Posted March 30, 2009 Share Posted March 30, 2009 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. Quote Link to comment Share on other sites More sharing options...
ober Posted March 30, 2009 Share Posted March 30, 2009 What version of mysql are you using? MySQL doesn't support subqueries until version 5. Quote Link to comment Share on other sites More sharing options...
lonewolf217 Posted March 30, 2009 Share Posted March 30, 2009 i dont see a session_start() anywhere you have to initialize a session before you can use it Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.