Declaring a SESSION Variable

thumbliner

Hi Guys,

I am having a problem declaring the SESSION VARIABLE for 'firstname' column in my code. I don't know why. Please show me a way to declare it.

Thanks.

$LoginRS__query=sprintf("SELECT pilot_callsign, password, staff_level, firstname FROM pilots WHERE activated = 1 AND pilot_callsign=%s AND password=%s",
  GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 

  $LoginRS = mysql_query($LoginRS__query, $brn_system) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {

$loginStrGroup  = mysql_result($LoginRS,0,'staff_level');

if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}

//declare two session variables and assign them
$_SESSION['MM_Username'] = $loginUsername;
$_SESSION['MM_UserGroup'] = $loginStrGroup;

Undrium

Sorry if I completely missunderstand what you mean:

$_SESSION['MM_Firstname'] = $LoginRS['firstname'];

Does that work?

thumbliner

No its not working. Why can' I make this work?

I tried almost every possible code.

Undrium

Are you sure you can get that variable out of your database? What happens if you echo it? Try to also echo mysql_error() after you query your db. Also does your other session variables work?

thumbliner

The other variable is working perfectly and when I echo it on the other page, it shows without any problem.

But when I echo this firstname variable, it just doesn't show.

I am sure the column has a value
I am sure the data can be retrieved as other pages are able to retrieve from the db.

I have no clue what is going wrong. I don't know PHP. Dreamweaver has been coding for me so far. But now I have hit a road block.

Is there any any other way to code this page?

A. Login form
B. Level Restricted Access
C. Query certain columns from DB depending on the user
D. Set the session variable

Undrium

If you can't echo the firstname variable you most likey have a problem with your database. Does mysql_error() say anything?

thumbliner

Even mysql_error() doesn't show up anything.

Anyways, I found another way. Thanks anyways.