SESSION variables not showing up!

[loureiro]

hi,

Im having a problem with my session variables. I cant seem to bring them up the first time after i do an update. so heres what happens...first the user logins...then they change some details and it updates the database...next i tell them they have to relogin so i get them to click a link which opens a new window to the login, empties the variables, closes the session and closes the current window. then they relogin but when they do that they cannot see any of their details from the previous update. until that is...they relogin again for a second time

[leatherback]

I think you really should show us some of the code here.. Hard to tell. Sounds like a error in the order of your commands..

J.

[loureiro]

//remove $_POST
	extract ($_POST);

//Update database
$sqlUpdate = "UPDATE Company SET company = '$companyName',
			  address1 = '$address1',
			  address2 = '$address2',
			  city = '$city',
			  province = '$province',
			  country = '$country',
			  postal = '$postal',
			  telephone = '$telephone',
			  toll = '$toll',
			  fax = '$fax',
			  website1 = '$website1',
			  website2 = '$website2',
			  link1 = '$link1',
			  link2 = '$link2',
			  users = '$users',
			  logo1 = NULL,
			  logo2 = NULL,
			  image1 = NULL,
			  image2 = NULL,
			  details = '$details',
			  enabledFields = NULL,
			  payment = '$payment' WHERE companyID = '".$_SESSION["companyID"]."'";

//connect to database
require ("../config.php");
$dbh=mysql_connect ($LDHost,$LDUsername,$LDPassword) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($LDSGTool);

if(mysql_query($sqlUpdate))
{
  echo "<div id=\"row1\">
<div id=\"text\">
Your account has been updated successfully. In order to continue to use the client login you must relogin. You can do so at 
<a href=\"http://www.londondigitalone.com/login?username=".$_SESSION["username"]."&password=".$_SESSION["password"]."\" target=\"_blank\" onClick=\"closeWindow();\">
http://www.londondigitalone.com/login?username=".$_SESSION["username"]."&password=".$_SESSION["password"]."
</a></div></div>";
	}

mysql_close($dbh);

// Unset all of the session variables.
session_unset();
// Finally, destroy the session.
session_destroy();