Session data not passing to the next page

[bobf]

I hope it's OK to tag my question on to the end of your response?
I am struggling to carry variables through to the next page using sessions. I have the following:-

$result = mysql_query("SELECT `email`,`first_name`,`last_name`,'registered_on' FROM `wsd_members` WHERE `username`= '" . prepareData($_POST['username']) . "' and password = MD5('" . prepareData($_POST['password']) . "')");
      if ($result) {
        if ($frow = mysql_fetch_row($result)) {
          $email = $frow[0];
          mysql_query("UPDATE wsd_members SET last_logged_on = NOW() WHERE username = '" . prepareData($_POST['username']) . "'");
          session_start('MEMBERS');
          $_SESSION['username'] = stripData($_POST['username']);
          $_SESSION['email'] = $email;
          $_SESSION['first_name'] = $first_name;
          $_SESSION['last_name'] = $last_name;
          $_SESSION['registered_on'] = $registered_on;
          session_write_close();
// landing page
          header("Location: http://www.xx.co.uk/folderdb/members/index.php");
          exit(); 
        }
        else {
          $error = 'Invalid username or password';
 

My problem is that I can see username and email but I am not seeing the others.
Can you see anything in my code that could be causing my problems?

[bobf]

Resolved
Sorry Guys it was under my nose

if ($result) {
    if ($frow = mysql_fetch_row($result)) {
      $email = $frow[0];
      $first_name = $frow[1];
      $last_name = $frow[2];
etc.....
 

I think it is asking for help that gets my brain in gear!!

[Atli]

Hi.

I've split your question into it's own thread so it doesn't get mixed up with the responses to the Article.

Glad you found the problem. If I had a dollar every time I overlooked some minor detail like that I'd probably be a millionaire by now :)

Good luck with your project and feel free to post a new topic if you run into any more trouble.