How to update records using $wpdb?

Logic of my function was all wrong, should have sorted the result in $trans_array before the foreach loop.

Here is the updated code that worked, if anyone needs it:

function rkm_translation_update() {
    global $wpdb;
    $trans_row = $wpdb->get_row("SELECT * FROM id_item_lid", OBJECT, 0);
    $id = $trans_row->id;
    $item = $trans_row->item_id;
    $lid = $trans_row->lid;

    $trans_array = $wpdb->get_results("SELECT * FROM id_item_lid ORDER BY item_id");
    foreach ($trans_array as $trans) {
        $id_new = $trans->id;
        $item_new = $trans->item_id;
        $lid_new = $trans->lid;
        if ($item === $item_new) {
            $wpdb->update('wp_icl_translations', array('trid' => $id, 'source_language_code' => $lid), array('element_id' => $id_new, 'element_type' => 'post_post'));
        } else {
             $id = $trans->id;
             $item = $trans->item_id;
             $lid = $trans->lid;
             $wpdb->update('wp_icl_translations', array('trid' => $id, 'source_language_code' => $lid), array('element_id' => $id, 'element_type' => 'post_post'));
        }
    }
}

This is a bit of a dirty solution, when debugging is true, there are some warnings in the admin related to original post language, if it is missing, probably could be refined a bit more, but I couldn’t be bothered.

Related Posts:

  1. How to use $wpdb to delete in a custom table
  2. get_results on large datasets
  3. Is there a (better) way to access $wpdb results?
  4. Using $wpdb generates DB error
  5. How do you use prepare when asking for a list of id’s
  6. how to execute different sql query in non-sanitized $wpdb->get_results function
  7. WPDB update row with != in where clause
  8. Need help writing a $wpdb query
  9. show badge with count for pending items in custom post type
  10. WP Sql query multiple where clause
  11. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  12. Modify the structure of data returned by $wpdb
  13. Syntax for $wpdb->prepare when searching in two columns
  14. Confused by $wpdb->prepare
  15. How to display user_nicename and usermeta values by custom query in WordPress?
  16. Optimizing WordPress Queries – Removing Group By ID
  17. How can I combine one field using wpdb and group by?
  18. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  19. how to use $wpdb->prepare to update a custom table
  20. 301 Redirect Code
  21. WPDB Placeholders and second argument for prepared statements
  22. Increment integer field in database when WHERE needs to be dynamic [closed]
  23. Custom SQL query ORDER BY term_order
  24. Custom $wpdb returns unexpected time based results
  25. How to left join meta in queries [closed]
  26. wpdb->get_row is selecting the variable as a column name
  27. CREATE TABLE with dbDelta does not create table
  28. $wpdb query outputs php code instead of executing it
  29. wpdb query not working
  30. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  31. WPDB SQL Ignore `post_status` Parameter
  32. how to list all post that are in the custom taxonomy using $wpdb
  33. WPDB SQL query SELECT from category
  34. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  35. Creating an Angular factory from custom database table
  36. wpdb->update update the entire table instead of one row
  37. How do I update post based on meta_key in another table?
  38. How to set up prepared query using IN statement
  39. Custom database query to validate data
  40. Alter the main search query to search posts by coauthor user name
  41. Creates only one table and not the other
  42. Protect custom form from SQL injection
  43. looking for a way to allow users to backup the plugin db data(save as)
  44. SQL Query to select post title & post ID from a particular category
  45. Get comments after specific date
  46. query using wpdb in wordpress gets me no result
  47. Get count of rows based if column exists in two different tables
  48. query_vars doesn’t return query string (trying to get data from $wpdb)
  49. How do you properly prepare a %LIKE% SQL statement?
  50. How to parse row results from $wpdb -> get_results
  51. $wpdb->insert() and Values for Datetime Columns?
  52. Change post status based on meta value
  53. Speed optimization of $wpdb->get_results
  54. $wpdb is get_results escaped
  55. wpdb prepare: passing varible number of fields as second argument
  56. Wpdb query for comment meta for current post
  57. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  58. Select from wp_post and multiple meta_value from wp_postmeta
  59. create drop down menu in theme customizer from custom db
  60. Are there risks associated with using wp_options table using wpdb to update theme options
  61. $wpdb->insert is running multiple times on page load, but only called once
  62. Get an array of meta_values for a user meta_key
  63. Can’t get result from sql using ajax result
  64. WordPress (on AWS ubuntu) database Fails “Connection refused in .. /wp-includes/wp-db.php on line 1531”
  65. How to get entry by title by using wpdb
  66. $wpdb not being defined in function: Fatal error: Call to a member function query() on a non-object
  67. WordPress is trimming leading 0s
  68. WPDB SQL query with prepare() returning variable, not db value
  69. get_results not returning anything
  70. Save data from a checkbox to a wpdb array
  71. WP-PostRatings: list current user’s rated posts
  72. WPDB Join with custom table
  73. $wpdb->prepare affecting the query?
  74. Getting values from wpdb
  75. Mowing site to another domain in simplest way
  76. Why is this $wpdb query looping 5 times?
  77. wpdb query not returning results containing single quotes
  78. duplicate entries in database while using save_post or wp_insert_post
  79. Unknown column ‘siteurl’ in ‘where clause’ WPDB outside
  80. Inserting a MySQL record into a table with an array of field names and an array of values
  81. Incorrect Use of wpdb::prepare()
  82. Passing a SQL query to the WP Query
  83. Creating multiple tables with Plugin
  84. sort title descending with title with number
  85. Escaping a WPDB Object in One Shot
  86. Correct and secure way to access a custom SQL database in a custom PHP template file
  87. Create a stored procedure on plugin activation
  88. Get last element from wpdb as a string
  89. $wpdb query for price in custom field value
  90. Update all fields of table with ON DUPLICATE KEY UPDATE command
  91. WordPress – wpdb query does not list same result as sql query
  92. What is the best practice to initialise $wpdb by loading wp-load.php?
  93. $wpdb->get_results in not an array
  94. How to make iteration on wpdb->update or query statement?
  95. Querying multiple meta_keys in WordPress SQL query
  96. Custom WordPress SQL Query 4 posts per custom taxonomy
  97. Jeditable Plugin working as it should – scope issue?
  98. wpdb LIKE request shows all database data
  99. How do I change the datetime format from ( ‘y-m-d’ ) to ( ‘d m y’ ) [closed]
  100. WP Recommended Table Exclusions?