Can’t seem to get set_blog_id working, it just doesn’t reset the blog ID

Use switch_to_blog( $new_blog_id ) instead.

You can find the function in wp-includes/ms-blogs.php.

Update

$wpdb->set_blog_id() doesn’t change the global variable $blog_id which is returned by get_current_blog_id(). switch_to_blog() does change the global variable.

Related Posts:

  1. How to fetch an array in $wpdb?
  2. Undefined offset: 0
  3. $wpdb->get_results in not an array
  4. $wpdb->get_row() only returns a single row?
  5. How to return number of found rows from SELECT query
  6. wpdb->insert: do I need to prepare against SQL injection?
  7. How to parse row results from $wpdb -> get_results
  8. Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
  9. what is the way to see the currently executing query in wordpress?
  10. Fetch array with $wpdb
  11. How do I check for a duplicate record before inserting using wpdb
  12. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  13. How to use $wpdb to delete in a custom table
  14. $wpdb->insert not working in any way
  15. WPDB prepare – like % – placeholders?
  16. Can i use php sql functions instead of $wpdb?
  17. $wpdb->update multiple rows, like IN in normal SQL
  18. Matching database content types to PHP types
  19. $wpdb->get_results(…) returns empty array despite correct query
  20. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  21. get_results on large datasets
  22. $wpdb->insert() and Values for Datetime Columns?
  23. $wpdb->last_error doesn’t show the query on error
  24. $wpdb->delete column values IN ARRAY()?
  25. wpdb::prepare was called incorrectly
  26. Avoiding “Usage of a direct database call is discouraged”
  27. Display data from a non wordpress database on a page template
  28. dbDelta does not create Table, but returns success
  29. Theoretical Multi-Server WordPress Setup with Shared Users
  30. Custom query to get post names beginning with a digit
  31. Change post status based on meta value
  32. wpdb->insert not working
  33. queries inside of a class
  34. Saving custom form data into database
  35. passing variables as parameters to stored procedures via wpdb from php-script
  36. Get data from database table by post_id to get data from second database table
  37. Stackoverflow type of badge plugin giving warnings in WordPress 3.5
  38. wp-content/db.php : where is this file?
  39. Quotes in table name
  40. Delete/replace img tags in post content for auto published posts [closed]
  41. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  42. $wpdb->get_results() returns good result only in first foreach iteration
  43. $wpdb->insert – inserting multiple rows
  44. How to display only first value of database column in WordPress
  45. Speed optimization of $wpdb->get_results
  46. Print out WordPress user ID – two sites with same code but different output
  47. How do I create a single.php for a specific category?
  48. $wpdb prepared with search term
  49. WPDB->insert with special characters
  50. What does wp_update_post() do that the $wpdb class does not?
  51. How Can I Use $wpdb in PayPal IPN file?
  52. $wpdb is get_results escaped
  53. $wpdb->query() multiple query support
  54. wpdb-> not adding prefix to custom table
  55. Is there a (better) way to access $wpdb results?
  56. Using $wpdb generates DB error
  57. WordPress insert NOW() in TIMESTAMP column returns all zeros
  58. Inserting data into `post meta` table?
  59. How do you use prepare when asking for a list of id’s
  60. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  61. $wpdb prepare issue with mysql DATE_FORMAT
  62. How-To: wpdb Insert Record With Date
  63. WPDB: how to get the value of a field in a custom database table
  64. $wpdb->prepare not working with update table prefix
  65. How to use prepare to query with variables
  66. Use $wpdb in wordpress theme files
  67. Can’t use get_results() in ajax query
  68. How to pass NULL in where array for $wpdb->update
  69. how to execute different sql query in non-sanitized $wpdb->get_results function
  70. $wpdb not returning data
  71. PHP syntax error when using wpdb update?
  72. Get random row from custom table
  73. How to get top 10 user is based on user meta value
  74. $wpdb Query Result not coming but in phpmyadmin it works [closed]
  75. WPDB update row with != in where clause
  76. store custom WP table names in a global variable
  77. wpdb prepare: passing varible number of fields as second argument
  78. $wpdb insert array
  79. I am not understandinhg $wpdb->prepare correctly
  80. Wpdb query for comment meta for current post
  81. How to update records using $wpdb?
  82. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  83. Problem in creating table through plugin code
  84. “The plugin generated 2694 characters of unexpected output…” on Plugin activation, CREATE TABLE sql command not working
  85. I want to update my postcontent with $wpdb
  86. How to iterate through database until it find a match
  87. How to save html and text in the database?
  88. Export WordPress Table to CSV from page
  89. XOR functionality for meta_query
  90. How to email user after inserting the username in database in WordPress
  91. $wpdb->replace / Replace or update primary key
  92. Join inside a wpdb query.. confused!
  93. WordPress get pagination on wpdb get_results
  94. Create an array with a string key from wpdb->get_results
  95. $wpdb – do you have to use foreach even if there will always only be one result?
  96. How to Modify this $wpdb query to accept an array of post statuses
  97. Replicating the WP_Query ‘s’ param with $wpdb
  98. Why doesn’t my insert query work?
  99. Need help writing a $wpdb query
  100. How to prevent $wpdb->prepare stripping a leading zero in variable value?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)