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']}"; ?>

you are echoing the session id, try changing the line

<?php echo "Welcome, {$_SESSION['SecurityAssist_UserID']}"; ?>

to

<?php echo "Welcome, ".$row_welcome['UserFirstName']; ?>

which will take the value from your recordset

Hi, I m Trying to set user firstname to show after login but it dont work for me...

When I do it it show me the first persona that was register on my web site but it wont show the person that is Login...

I need help please...

on the login page, open the server behaviors panel, then double click the Authenticate user server behavior. On the third step of the authenticate user server behavior add the User name column to the list of columns to store in a session variable on login.

on the page you wish to show the users name, drag the username session variable from the bindings panel.

Hi, Thank you for the firts part tip... It work but it show the ID number and it wont show the name????

if it is showing the id number, you have used the binding for the user ID session, not the user name session.

Hello Mr. Jason,

Thank you for the tips... It work out putty good for me...

Thanks!

Hi, I will like to know how I can keep my self uptodate when I get a new user via e-Mail...

Also I want to know how to see user email and login detail in case I have to check something on them...

Please.....

you would need to use universal Email to send an email when a new user is registered.


to create a user management section, you would need to use data assist.

This post has been deleted.