SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]

from is a keyword in SQL. You may not used it as a column name without quoting it. In MySQL, things like column names are quoted using backticks, i.e. `from`.

Personally, I wouldn’t bother; I’d just rename the column.

PS. as pointed out in the comments, to is another SQL keyword so it needs to be quoted, too. Conveniently, the folks at drupal.org maintain a list of reserved words in SQL.

Related Posts:

  1. PDO with INSERT INTO through prepared statements
  2. How to delete from multiple tables in MySQL?
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Unknown column in ‘field list’ error on MySQL Update query
  5. Unknown column in ‘field list’ error on MySQL Update query
  6. MySQL – Operand should contain 1 column(s)
  7. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  8. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  9. MySQL create table if not exists and insert record only if table was created
  10. How do I use properly CASE..WHEN in MySQL
  11. How can I do a FULL OUTER JOIN in MySQL?
  12. MySQL query String contains
  13. What’s the difference between VARCHAR and CHAR?
  14. PDOException SQLSTATE[HY000] [2002] No such file or directory
  15. Case statement in MySQL
  16. PDOException SQLSTATE[HY000] [2002] No such file or directory
  17. How to declare a variable in MySQL?
  18. MySQL Cannot Add Foreign Key Constraint
  19. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  20. How to split the name string in mysql?
  21. How do I import an SQL file using the command line in MySQL?
  22. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  23. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  24. mysql Foreign key constraint is incorrectly formed error
  25. MySQL: Invalid use of group function
  26. Simple PHP Pagination script
  27. How can I return pivot table output in MySQL?
  28. Compare dates in MySQL
  29. MySQL “WITH” clause
  30. MySQL Multiple Joins in one query?
  31. Error Code: 2013. Lost connection to MySQL server during query
  32. MySQL syntax for Join Update
  33. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  34. PDO bindParam() with prepared statement isn’t working
  35. how to drop partition without dropping data in MySQL?
  36. Simple way to calculate median with MySQL
  37. Creating a search form in PHP to search a database?
  38. How can I do ‘insert if not exists’ in MySQL?
  39. Error 1046 No database Selected, how to resolve?
  40. MySQL Error 1264: out of range value for column
  41. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  42. Commands out of sync; you can’t run this command now
  43. How to SUM and SUBTRACT using SQL?
  44. How can I prevent SQL injection in PHP?
  45. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  46. How can I do ‘insert if not exists’ in MySQL?
  47. Cast from VARCHAR to INT – MySQL
  48. How do you force mysql LIKE to be case sensitive?
  49. MySQL – UPDATE multiple rows with different values in one query
  50. Call to a member function on null?
  51. How to create a MySQL hierarchical recursive query?
  52. ERROR 1148: The used command is not allowed with this MySQL version
  53. Insert into a MySQL table or update if exists
  54. How to round down to nearest integer in MySQL?
  55. MySQL starts with searching issue
  56. Query to convert from datetime to date mysql
  57. Is it possible to GROUP BY multiple columns using MySQL?
  58. MySQL error: key specification without a key length
  59. Best way to test if a row exists in a MySQL table
  60. Check if MySQL table exists without using “select from” syntax?
  61. MySQL equivalent of DECODE function in Oracle
  62. mysql update column with value from another table
  63. The used SELECT statements have a different number of columns
  64. What is the advantage of using try {} catch {} versus if {} else {}
  65. MySQL: Can’t create table (errno: 150)
  66. Join vs. sub-query
  67. Deprecated: mysql_query() [duplicate]
  68. Alternative to except in MySQL
  69. Fatal error: Call to a member function query() on null
  70. Equivalent of explode() to work with strings in MySQL
  71. ROW_NUMBER() in MySQ
  72. MySQL OPTIMIZE all tables?
  73. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  74. MySQL – Get row number on select
  75. PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/website/public_html/facebook/fbclogin.php on line 57 [duplicate]
  76. MySQL error: Unknown column in ‘where clause’
  77. How to truncate the text returned for a column in a MySQL query
  78. Using union and order by clause in mysql
  79. MySQL LIKE IN()?
  80. Transaction when using WP functions rather than vanilla SQL?
  81. How to get the list of WooCommerce product image of a certain category from database?
  82. How to make WordPress plugin check for database changes and then do something?
  83. How to Join two tables from separate databases within WordPress
  84. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  85. register_activation_hook isn’t adding table to DB
  86. Importing Geo data into wordpress database
  87. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  88. Use $wpdb or other PHP script method to find/replace in WP database
  89. How can I add a new row in a separate database when someone registers via WordPress?
  90. Pull MySQL data from multiple tables and merge into 1 PHP array
  91. Use variable in SQL statement
  92. mySQL queries are executed twice on wordpress website
  93. making php value numeric
  94. Database SQL query error
  95. How to run complex query using PHP
  96. How to get database connection details without longing to cpanel in WordPress?
  97. Inserting other fields to existing registration form in a WordPress theme
  98. SQL Query Search page
  99. can’t delete a row from post_meta table
  100. Conditional statement within WP SQL query

Leave a Comment