I am not sure what is happening. I have a login page, once the user logs in, sessions are set. On the next page I have welcome <?php echo $_SESSION['Username']; ?>
It seems like half of the time the session is ok then half the time it is blank.
What may be causing this?
Here is the code:
<?PHP session_start();?>
<?php require_once('/connUserareas.php'); ?>
<?PHP
$date = date('Y-m-d h:i:s');
?>
<?php
mysql_select_db($database_connUserareas, $connUserareas);
$query_rsNews = "SELECT * FROM news WHERE news.Archive = 0";
$rsNews = mysql_query($query_rsNews, $connUserareas) or die(mysql_error());
$row_rsNews = mysql_fetch_assoc($rsNews);
$totalRows_rsNews = mysql_num_rows($rsNews);
$colname_rsUser = "1";
if (isset($SESSION['Username'])) {
$colname_rsUser = (get_magic_quotes_gpc()) ? $SESSION['Username'] : addslashes($SESSION['Username']);
}
mysql_select_db($database_connUserareas, $connUserareas);
$query_rsUser = sprintf("SELECT members.UserKey, members.Username, members.CustNum, members.Password, members.DisplayName, members.LastLogin, members.UserLevel, companynames.CustNum, companynames.CompanyName FROM members, companynames WHERE members.Username = '%s' AND companynames.CustNum = members.CustNum", $colname_rsUser);
$rsUser = mysql_query($query_rsUser, $connUserareas) or die(mysql_error());
$row_rsUser = mysql_fetch_assoc($rsUser);
$totalRows_rsUser = mysql_num_rows($rsUser);
?>
<?PHP
$SESSION['CustNum'] = $row_rsUser['CustNum']
?>
<?PHP
$SESSION['UserKey'] = $row_rsUser['UserKey']
?>
<?PHP
$SESSION['UserLevel'] = $row_rsUser['UserLevel']
?>
Thanks
jm
