title: PHP - First time login page
body: <p>I am trying to setup a website that will know if a user has logged into the website before. The MYSQL table has a username, password and firstLogin field. The firstLogin field is an integer field containing 1 if the user has not logged and 2 if they have logged in in the past. </p>
  
  <p>The login sysetm logs in and starts a session as it should do therefore i am certain the count is returning the value of 1. The problem that i am having is the website is going straight to homepage.php even if the firstLogin integer is set to 1. The website should be going to welcome.php whilst performing an update operation to change the integer to 2. Ive been staring at this for about a week now. Hope you can help. </p>
  
  <pre><code>&lt;?php
  $host="localhost"; // Host name
  $username=""; // Mysql username
  $password=""; // Mysql password
  $db_name=""; // Database name
  $tbl_name=""; // Table name
  
  
  // Connect to server and select databse.
  mysql_connect("$host", "$username", "$password")or die("cannot connect");
  mysql_select_db("$db_name")or die("cannot select DB");
  
  // username and password sent from form
  $myusername=$_POST['myusername'];
  $mypassword=$_POST ['mypassword'];
  
  // To protect MySQL injection (more detail about MySQL injection)
  $myusername = stripslashes($myusername);
  $mypassword = stripslashes($mypassword);
  $myusername = mysql_real_escape_string($myusername);
  $mypassword = mysql_real_escape_string($mypassword);
  
  $sql="SELECT username, password,firstLogin FROM $tbl_name WHERE username='".$myusername."' and password= sha1('".$mypassword."'";
  $result=mysql_query($sql);
  
  // Mysql_num_row is counting table row
  $count=mysql_num_rows($result);
  // If result matched $myusername and $mypassword, table row must be 1 row
  
  if($count==1){
  
      $row = mysql_fetch_array($result);
       print_r($row); 
       exit;
  
      if ($row ['firstLogin']=="1")
          {
          $sql2 ="UPDATE $tbl_name SET firstLogin = '2' WHERE username ='".$myusername."'";  
          session_start();
  
          session_register("myusername");
          session_register("mypassword");
          header("welcome.php");
          }
          else
  
          {
          session_start();        
          session_register("myusername");
          session_register("mypassword");
          header("location:home.php");
          }
          }else
       {
      echo "Wrong Username or Password";
  }
  ?&gt;
  </code></pre>