title: MySQL Syntax error from INSERT INTO email address
body: <p>I'm having trouble inserting an email address into a MySQL database.  I'm getting the dreaded 1064 error like so..</p>
  
  <p><em>Error creating new user You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@email.com, password, 20)' at line 1 -- 1064</em></p>
  
  <p>So I'm guessing I need to escape the @ in the email variable?  But nothing i do seems to please Maria.  Generating the query in PHPMyAdmin was no help either.
  Any advice gratefully accepted.</p>
  
  <pre><code>// update SQL
      $sql2 = "INSERT INTO members (username, email, password, balance) VALUES ($new_player, $new_email, $new_password, 20)";
      if ($db-&gt;query($sql2) == TRUE) {
              echo "** New User Created **&lt;BR&gt;";
                  } else {
                  echo "Error creating new user " . $db-&gt;error." -- ". $db-&gt;errno ."&lt;BR&gt;";
      }
  </code></pre>