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 ‘WHERE `id` [closed]

by

You cannot have a WHERE clause in a basic INSERT syntax. What you really want, i think, is an UPDATE statement,

UPDATE cafes SET deal="$deal" WHERE id = $id

As a sidenote, the query is vulnerable with SQL Injection if the value(s) of the variables came from the outside. Please take a look at the article below to learn how to prevent from it. By using PreparedStatements you can get rid of using single quotes around values.

More Related Contents:

  1. Order results from two queries based on time in second query [closed]
  2. Query database then email posts from where user is subbed to
  3. Save the data into a database and return another value from database using PHP
  4. Im trying to create some temporary tables in mysql using php
  5. How can I do ‘insert if not exists’ in MySQL?
  6. How to apply bindValue method in LIMIT clause?
  7. Can I parameterize the table name in a prepared statement?
  8. Getting raw SQL query string from PDO prepared statements
  9. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  10. MySQL Prepared statements with a variable size variable list
  11. PDO with INSERT INTO through prepared statements [closed]
  12. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  13. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  14. Comma separated values in MySQL “IN” clause
  15. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  16. Doing a while / loop to get 10 random results
  17. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  18. How to execute raw queries with Laravel 5.1?
  19. Simple PHP SQL login troubleshooting
  20. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  21. How do you do multiple SQL statements in one mysql_query?
  22. MySql PHP select count of distinct values from comma separated data (tags)
  23. Laravel Eloquent get results grouped by days
  24. how do I get month from date in mysql
  25. php/mysql zip code proximity search
  26. Do I have to use mysql_real_escape_string if I bind parameters?
  27. Updating column so that it contains the row position
  28. PDO and MySQL ‘between’
  29. MySQL Join Multiple Rows as Columns
  30. Aggregated query without GROUP BY

Leave a Comment