title: Mysql insert successful but not visible
body: <p>I have a database with a table called games. People can send invites to each other in an app and then a row is inserted in this table. </p>
  
  <p>Recently it stopped working. When I insert a new row, php (and phpmyadmin when I insert it manually) says that the update was succesful (the query function returned true), but I can't find the freshly inserted rows in the table :(</p>
  
  <p>I really don't know what could possibly cause this. I've already checked the permissions and restarted the server but that didn't solve the problem.</p>
  
  <p>The table has the following columns:</p>
  
  <pre><code>id (int)
  black (varchar)
  white (varchar)
  onturn (varchar)
  gamestarted (bool)
  inviter (varchar)
  opponent (varchar)
  field (varchar)
  timestarted (datetime)
  lastmove (datetime)
  lastmove_pushsent (bool)
  </code></pre>
  
  <p>and the query I'm trying is:</p>
  
  <pre><code>$query = "INSERT INTO games VALUES ('','','','','0','$loginName','$opponent','11111111111111111111000000000022222222222222222222','$timeInvite','','')";
  $this-&gt;db-&gt;query($query);
  </code></pre>