title: PHP won't update MySQL tables
body: <p>I have a "Windows Apache MySQL PHP" server on my laptop. I get absolutely no error messages, but when I send things to MySQL via PHP script, nothing happens in MySQL (I also sent something via the MySQL command prompt and it looks like it just made a test table and didn't put anything in it like I asked, but I'm not positive I did everything I should have in this case). I've rescripted my whole page a different way and it still doesn't work.</p>
  
  <p>Here is a picture of my form and how the table looks in MySQL:</p>
  
  <p><a href="https://i.stack.imgur.com/YIBvm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YIBvm.png" alt="http://tinypic.com/view.php?pic=21kjgno&amp;s=5"></a></p>
  
  <p>System:</p>
  
  <p>Windows 7 Home Premium SP1 64 bit--
  Apache 2.4.4 32 bit with ssl0.9.8--
  PHP 5.4.11 32 bit VC9--
  MySQL 5.5.31 64 bit with Navicat Lite</p>
  
  <pre><code>&lt;?php  
  define('DB_HOST', 'localhost');
  define('DB_NAME', 'projectedin');
  define('DB_USER','root');
  define('DB_PASSWORD','');
  
  $con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
  $db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " .mysql_error());
  
  function NewUser()
  {
      $userName = $_POST['username'];
      $firstname = $_POST['firstname'];
      $lastname = $_POST['lastname'];
      $password =  $_POST['password'];
      $birthday =  $_POST['birthday'];
      $gender =  $_POST['gender'];
      $query = "INSERT INTO users (username,firstname,lastname,password,birthday,gender) VALUES ('$username','$firstname','$lastname','$password','$birthday','$gender')";
      $data = mysql_query ($query)or die(mysql_error());
      if($data)
      {
          echo "YOUR REGISTRATION IS COMPLETED...";
      }
  }
  
  function SignUp()
  {
      if(!empty($_POST['username']))   //checking the 'user' name which is from Sign-Up.html, is it empty or have some text
      {
      $query = mysql_query("SELECT * FROM users WHERE username = '$_POST[username]' AND password = '$_POST[password]'") or die(mysql_error());
  
      if(!$row = mysql_fetch_array($query) or die(mysql_error()))
      {
          newuser();
      }
      else
      {
          echo "SORRY...YOU ARE ALREADY REGISTERED USER...";
      }
      }
  }
  if(isset($_POST['submit']))
  {
      SignUp();
  }
  mysqli_close ($con);
  ?&gt;  
  </code></pre>