I can’t update my data through $wpdb

You’re missing your where statement. You need to tell wpdb which row it should be updating, otherwise you’re looking to insert rather than update.

From the $wpdb::update Codex:

wpdb->update( string $table, array $data, array $where, array|string $format = null, array|string $where_format = null );

Related Posts:

  1. How to return number of found rows from SELECT query
  2. $wpdb->delete column values IN ARRAY()?
  3. Update results, Before deleting the related category [closed]
  4. Add row to custom database Table and delete all rows older than 1 day
  5. select a single val though a table in wordpress
  6. Using wpdb to connect to a different database is not working
  7. MySQL database migration to WordPress
  8. Putting form result in my database
  9. Check if post of title already exists
  10. Changing user_nicename
  11. Does WordPress cache get_user_meta() results?
  12. WordPress will not operate correctly
  13. How to Join two tables from separate databases within WordPress
  14. error importing localhost export file to server
  15. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  16. How to sort results from a custom database table
  17. Import 10,000 Users into WordPress WITH a specific ID for each user
  18. WPDB: how to get the value of a field in a custom database table
  19. WP database error for comments_popup_link()
  20. if statement on database query
  21. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  22. No wp-config.php file on local install of wordpress – site still displays
  23. WordPress get pagination on wpdb get_results
  24. Different database query in function.php using mysqli
  25. Ajax $wpdb not returning table data
  26. Converting MYSQL to WordPress $WPDB
  27. Why is variable not working on custom sql query using wpdb?
  28. Show MySQL errors that occur when I excute $wpdb->insert()
  29. database interactions using OOP
  30. Can’t get wp_insert_post to work
  31. Trying to establish connection to External Database
  32. Create WP_Query to search for posts by their categories or their parent/child categories
  33. How to insert a single row to WP database table?
  34. WSoD being caused by this piece of code
  35. WordPress not reflecting changed of the database
  36. $wpdb->update with multiple parameters gives error
  37. How WordPress reacts to a lack of memory of the server [closed]
  38. wp query foreach deleting record returning only first or last item
  39. database sent to a JSON file
  40. inserting a post from an extern php file but post content doesn’t show on wp site
  41. Database query works fine outside WordPress
  42. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  43. $wpdb->insert() does not Insert record in a table
  44. Help with a $wpdb MySQL Query
  45. Not connecting to database in file with multiple MySQL connections
  46. How to retrieve the data from the sever and displaying it in a page?
  47. $wpdb returns duplicate posts
  48. Mixing variables into an array when inserting values
  49. wpdb prepare insert table doesn’t work
  50. Should I use WordPress to skin a database website?
  51. Creating Database Table vs. Adding MetaData to Post & User
  52. How can I add a new row in a separate database when someone registers via WordPress?
  53. Basic wpdb update question
  54. wpdb Cannot Update column in Database
  55. Output: “Array”
  56. How to use mysql LIKE with wpdb?
  57. Delete database record using plugin from admin panel
  58. Wpdb get->results to out the the month from the db
  59. How do I prepare strings for insertions as values into a MySQL table?
  60. How to use AJAX in WordPress in MYSQL query?
  61. WPDB – Read and write value from / to database
  62. form $_post action value gets truncated after it passes through two forms
  63. How to Generate a list of Most Commented post?
  64. Why won’t this wpdb get_results query return results?
  65. Why when I create a new post I found 2 record related to this post into the posts database table?
  66. Adding data to custom wordpress database table
  67. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  68. populate select options from extra mysql table data
  69. MySQL Query Returns Array () In Shortcode
  70. Add posts to custom table in database instead of wp_posts
  71. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  72. Passing in MySQL prepare statement parameter separately throwing error
  73. Convert a column of a table containing an Array as response in HTML
  74. Database SQL query error
  75. Please help! I have a problem with getting wordpress databas
  76. Error establishing a database connection (Set-up locally)
  77. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  78. Conditional formatting on data fetched from MYSQL
  79. How to grab data from input and store it into custom table in database?
  80. Insert data from form to database
  81. Rewrite SQL query as a prepared statement and use in foreach loop
  82. Advanced WordPress SQL Query
  83. can’t delete a row from post_meta table
  84. MySQL query in WordPress with AJAX
  85. How to set max users to 17.000
  86. Passed variable gets undefined variable error on insert on next page
  87. two wordpress sites, two themes, one database, same content
  88. Insert double entry in DB
  89. How to fetch results from database
  90. How to connect database table to each registered wordpress user.
  91. Using the same shortcode to show any table from the database
  92. Querying multiple meta_keys in WordPress SQL query
  93. Custom query_posts() parameter
  94. How to edit the default database of WordPress [closed]
  95. Display total count of products in orders of a specific order status
  96. Execute multiple PHP Snippets causes error?
  97. Custom form that stores data in mysql database
  98. How to get data (not value or name) from radio options to POST to database
  99. How can I update a value of a field depending on outside source?
  100. Can’t insert into a database wordpress