title: msqli does not INSERT
body: <p>im trying to insert data from a form (via POST) into a MySQL database, it does not show any errors, but it does not show up when I check it in phpMyAdmin.</p>
  
  <pre><code>    &lt;?php
  
      $amount = $_POST["amount"];
      $unit = $_POST["unit"];
      $date = date('Y-m-d H:i:s');
  
      $host = "localhost";
      $user = "root";
      $pass = "";
      $db = "finance";
      $table = "silver";
  
      $mysqli = new mysqli($host, $user, $pass, 'finance');
  
      if(!$mysqli)
         {
         echo "&lt;div class=\"error\"&gt;";
         echo "No connection can be established";
         echo "&lt;/div&gt;";
         die();
         } 
  
     if ($unit = "gram") $amount = $amount * 28.3495231;
  
     // create query
     $query = "INSERT INTO 'silver'.'finance' (
      'Transaction_Num',
      'dtStamp',
      'Amount'
     ) 
     VALUES (
     NULL, \'2013-07-03 06:18:16\', \'1\'
     );";
  
     // execute query
     $mysqli-&gt;query($query);
     ?&gt;
  </code></pre>
  
  <p>I'm running this on XAMPP 1.8.2 w/ PHP 5.4.16, Apache 2.4.4 and
  MySQL 5.6.11 on Windows XP.</p>