title: Migration Issues Updating MySQL
body: <p>I've migrated a custom PHP application from a Linux VPS to Windows Azure Websites, and it appeared that the only issue was the replacement of PHP_mail with SendGrid. Currently this application is completely written from scratch without any framework and uses MySQL for data storage. When migrating the application, I made a .sql file and used MySQL Workbench to create the tables on my new database server.</p>
  
  <p>The issue that I am finding is that I can log in with current users, however, I cannot update the tables successfully. There is no sign of the application adding another row. However, the application acts as if it was a success, and continues to a "success" page. However, no new session is created since there wasn't a user created. </p>
  
  <p>The differences I can tell between the two databases is that the original table names had a capital letter while on the new db server, they are all lowercase table names.</p>
  
  <p>I've tried changing the PHP version up and down from 5.4, and I've not made any modifications to the MySQL statements in the code.</p>
  
  <p>Out of your experience, what can I do to help me find the problem?</p>
  
  <p>EDIT:</p>
  
  <p>Here's portion of the file that should be updating the data server:</p>
  
  <pre><code>&lt;?php
  session_start();
  // store session data
  if ($_SESSION['employerID']&lt;&gt;'') {
      header("Location: account_details.php");
  }
  if (($_POST["fname"]&lt;&gt;"") &amp;&amp; ($_POST["email"]&lt;&gt;"")) {
      include ("config/config.php");  
      getConnect();
      $stmt = "insert into tblemployer (shortCode,company, fName, lName,email,address,city,state,zip,password) values ('".mysql_escape_string($_POST["shortCode"])."','".mysql_escape_string($_POST["company"])."','".mysql_escape_string($_POST["fname"])."','".mysql_escape_string($_POST["lname"])."','".mysql_escape_string($_POST["email"])."','".mysql_escape_string($_POST["address"])."','".mysql_escape_string($_POST["city"])."','".mysql_escape_string($_POST["state"])."','".mysql_escape_string($_POST["zip"])."','".md5($_POST["password"])."')";
      //echo $stmt;
      $query = mysql_query($stmt);
  
      $EID=mysql_insert_id();
      $_SESSION['employerID']=$EID;
      $_SESSION['userName']=$_POST["company"];
      $stmt = "insert into tblmembership (status, employerID, membershipID) values ('0','".$EID."','".mysql_escape_string($_POST["membership"])."')";
      //echo $stmt;
      $_SESSION['MID']=$_POST["membership"];
      $query = mysql_query($stmt);
      header( 'Location: corp_payment.php' ) ;
  
  }   
  
  ?&gt;
  </code></pre>