Making User's Firstname appear after Login
Hello please, I am having a problem with getting security assist to make the user name appear after login. It keeps showing the user's ID number instead. I have tried creating a recordset and filtering it to point to the session variable "SecurityAssist_UserID" but it still doesnt seem to work. Please help. Find the code below
RECORDSET CODE
$colname_welcome = "-1";
if (isset($_SESSION['SecurityAssist_UserID'])) {
$colname_welcome = (get_magic_quotes_gpc()) ? $_SESSION['SecurityAssist_UserID'] : addslashes($_SESSION['SecurityAssist_UserID']);
}
mysql_select_db($database_TsrConn, $TsrConn);
$query_welcome = sprintf("SELECT UserTitle, UserFirstName FROM tsr_users WHERE UserEmail = %s", GetSQLValueString($colname_welcome, "text"));
$query_limit_welcome = sprintf("%s LIMIT %d, %d", $query_welcome, $startRow_welcome, $maxRows_welcome);
$welcome = mysql_query($query_limit_welcome, $TsrConn) or die(mysql_error());
$row_welcome = mysql_fetch_assoc($welcome);
THEN I ECHOED THE CODE BELOW IN THE BODY
<?php echo "Welcome, {$_SESSION['SecurityAssist_UserID']}"; ?>