title: Unable to insert to remote database C#
body: <p>I've been attempting to write to a remote database, however I keep receiving errors when I attempt <code>INSERT INTO</code>. I can read from the database just fine and have used to to make sure my connection is working. </p>
  
  <p>NOTE: I am using the MySQL extension.</p>
  
  <p>Here is a part of my function:</p>
  
  <pre><code>try
                  {
                      query = "INSTERT INTO users (user_name, password, admin) VALUES ('" + username + "', '" + password + "', '0')";
                      command = new MySqlCommand(query, databaseConnection.getConnection());
                      command.ExecuteNonQuery();
  
                      query = "INSERT INTO players (user_id, first_name, last_name, phone, email, japanese_schoolgirl, status) VALUES('" + username + "','" + firstName + "','" + lastName + "','" + phoneNumber + "','" + emailAddress + "','" + Convert.ToInt32(japaneseSchoolgirl) + "','" + Convert.ToInt32(status) + "')";
                      command = new MySqlCommand(query, databaseConnection.getConnection());
                      command.ExecuteNonQuery();
                  }
                  catch (Exception ex)
                  {
                      string error = "SQL query failed to add user to database \n" + ex;
                      MessageBox.Show(error, "Username Taken", MessageBoxButtons.OK, MessageBoxIcon.Error);
                  }
  </code></pre>
  
  <p>I receive the following error:</p>
  
  <blockquote>
    <p>MySql.Data.MySqlClient.MySqlException (0x80004005): you have an error
    in your SQL syntax; check the manual that corresponds to  your MySQL
    server version for the right syntax to use near 'INSERT INTO
    users(user_name, password, admin) VALUES ('Username1', 'pass1', ''0'
    at line 1</p>
  </blockquote>
  
  <p>As you can imagine, I'v already looked at the manual and cannot find anything wrong with my SQL syntax. Any insight would be greatly appreciated.</p>