MySQL query won't update database [closed]

by

You need to read up on sql injection and switch to PDO / mysqli and prepared statements.

The problem you have however, is caused by a reserved word, EXISTS, so the start of your query would have to look like:

INSERT INTO newsletteroptions (email, `exists`) VALUES ...

More Related Contents:

  1. Comma separated numeric values – PHP CodeIgniter
  2. How to add Hyperlink on php/html table that displays information from mysql database [closed]
  3. Notice: undifined index, but why?
  4. How to display errors for my MySQLi query? [duplicate]
  5. Automated or regular backup of mysql data
  6. Fatal error: Call to undefined function session_register()
  7. PHP: Warning: sort() expects parameter 1 to be array, resource given
  8. Save PHP array to MySQL?
  9. implement LIKE query in PDO
  10. PHP PDO prepared statement — MySQL LIKE query
  11. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  12. How can I use mysqli_fetch_array() twice?
  13. Best practice multi language website
  14. Executing multiple SQL queries in one statement with PHP
  15. MySQL db question marks instead of hebrew characters..?
  16. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  17. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  18. Easy way to export a SQL table without access to the server or phpMyADMIN
  19. using nulls in a mysqli prepared statement
  20. How can I count the numbers of rows that a MySQL query returned?
  21. How I can create installer for website. PHP mysql [closed]
  22. How to join two tables with ssp.class.php
  23. How to run the PHP script at scheduled time
  24. How to handle error for duplicate entries?
  25. How to handle PDO exceptions [duplicate]
  26. How to convert IPv6 from binary for storage in MySQL
  27. MySql PHP select count of distinct values from comma separated data (tags)
  28. mysql_insert_id() returns 0
  29. How do I get database column names in Laravel?
  30. Eloquent many-to-many-to-many – how to load distant relation easily

Leave a Comment