Update query PHP MySQL [duplicate]

by

You have to have single quotes around any VARCHAR content in your queries. So your update query should be:

mysql_query("UPDATE blogEntry SET content="$udcontent", title="$udtitle" WHERE id = $id");

Also, it is bad form to update your database directly with the content from a POST. You should sanitize your incoming data with the mysql_real_escape_string function.

More Related Contents:

  1. How to create this type of JSON data from PHP [closed]
  2. Create hyperlink from html table row to open record on a new page
  3. mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
  4. SELECT COUNT(*) AS count – How to use this count
  5. How to execute two mysql queries as one in PHP/MYSQL?
  6. Storing files in database Vs file system
  7. How to upload images into MySQL database using PHP code
  8. selecting unique values from a column
  9. Create a dynamic mysql query using php variables
  10. How can I Use Prepared Statements in CodeIgniter
  11. How to echo out table rows from the db (php)
  12. How to display Unicode data with PHP [duplicate]
  13. PDO fetchAll group key-value pairs into assoc array
  14. MySQL skipping first row
  15. How to reverse order output of a MySQL query
  16. MySQL statement takes more than minute to execute
  17. Turkish characters are not displayed correctly [duplicate]
  18. Using utf8mb4 with php and mysql
  19. how do I get month from date in mysql
  20. mysql_connect VS mysql_pconnect [closed]
  21. php/mysql zip code proximity search
  22. PHP prepared statements and transactions in a loop [duplicate]
  23. Mysqli multiple row insert, simple multi insert query [duplicate]
  24. Updating column so that it contains the row position
  25. No Database Selected – PHP & MySQL
  26. using mysql_close()
  27. Should I disable MySQL strict mode?
  28. Using PDO Prepared Statement and Incrementing a column value
  29. Displaying BLOB image from Mysql database into dynamic div in html
  30. Improve password hashing with a random salt

Leave a Comment