It’s really hard to understand what are you actually doing ( a refactor will help also). but for updating you can try: You will need the $id, show you tell which row to update. $wpdb->update( $wpdb->prefix . ‘tropix_dmin’, array( ‘post_name1’ => $arr), array( ‘id’ => $id ), array( ‘%s’ ), array( ‘%d’ ) );
Update 2 wordpress tables at once
Debugging db calls: $wpdb->insert works on test site, not on identical production site
A simpler approach would be to store a list/array of post-ids of the posts which have been marked read by the user in his user_meta. Then retrieve this array for every logged-in user, and run the wp_query using the post__not_in parameter with the array as the argument.
2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
It is a a bit of a stab in the dark, but I’m fairly confident that the problem is your foreach loop. It’s broken (it will not execute anything because only an empty statement (;) is affected, and you will probably want it to have a block that contains the rest of the code. As … Read more
Just from the top of my head (untested), would it be an idea to use clean_post_cache after the comment is deleted ?
problem in using wpdb->prepare and a string placeholder
How to fix slow comment query?
bindParam? WordPress 4.9.5 SQL LIKE statement %s and %LIKE%