title: why it is not updating url in database
body: <p>I have a page named <code>ques.php</code>. If the user's answer is correct he will be directed to next <code>ques1.php</code>. The answer posted by the user is checked by check.php and if it is correct I want to store the new URL (<code>ques1.php</code>) in the users account in the database.</p>
  
  <hr>
  
  <p>check.php</p>
  
  <pre><code>&lt;?php
  
    require_once("./include/membersite_config.php");
  
    if (!$fgmembersite-&gt;CheckLogin()) {
      $fgmembersite-&gt;RedirectToURL("login.php");
      exit;
    }
  
    mysql_connect("localhost", "root", "") or die(mysql_error()); 
    mysql_select_db("simplelogin") or die(mysql_error()); 
  
    $data = mysql_query("SELECT * FROM member") or die(mysql_error()); 
  
    while($info = mysql_fetch_array( $data )) {
      // print $info['username'];
      if ($info['username'] == $fgmembersite-&gt;UserName()) {
        $fullname = $info['name'];
        $username = $info['username'];
        $password = $info['password'];
        $email = $info['email'];
        $url = $info ['url'];
        break;
      }
    }
  
    $answer = $_POST['answer'];
    if ($answer == "correct") {
      "UPDATE `simplelogin`.`member`
       SET `url` = 'ques1.php'
       WHERE
         `member`.`name` = '$fullname' 
         AND `member`.`email` = '$email'
         AND `member`.`username` = '$username' 
         AND `member`.`password` = '$password' 
         AND `member`.`confirmcode` = 'y'
         AND `member`.`url` = '$url'";
  
      //in place of above update query i had also used
      //"UPDATE  member 
      //SET url = 'ques1.php'
      //WHERE username = '$username'"
  
      Header("Location:ques1.php");
  
    } else {
  
      Header("Location: ques.php");
  
    }
  
  ?&gt;
  </code></pre>
  
  <hr>
  
  <pre><code>function UserName() {
    return isset($_SESSION['user_name'])?$_SESSION['user_name']:'';
  }
  </code></pre>
  
  <hr>
  
  <p>login.php</p>
  
  <pre><code>&lt;?php
  
    require_once("./include/membersite_config.php");
  
    if (isset($_POST['submitted'])) {
  
      if ($fgmembersite-&gt;Login()) {
  
        //$fgmembersite-&gt;RedirectToURL("login-home.php");
  
        mysql_connect("localhost", "root", "") or die(mysql_error()); 
        mysql_select_db("simplelogin") or die(mysql_error());  
  
        $data = mysql_query("SELECT * FROM member") or die(mysql_error()); 
        while ($info = mysql_fetch_array( $data )) {
          if ($info['username']==($fgmembersite-&gt;SafeDisplay('username'))) {
            $url = $info['url'];
            break;
          }
        }
  
        $fgmembersite-&gt;RedirectToURL("$url");
  
      }
    }
  
  ?&gt;
  </code></pre>
  
  <p>In <code>login.php</code> I am retrieving the URL from the database and redirecting the user - by default URLfor the user is ques.php.</p>
  
  <p>Why is my query not updating the url in my database?</p>