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.
This a php syntax error, try: foreach($last_updated_comment as $key => $last_comment_date){ print_r( $last_comment_date ); echo “<br /><br />”; }
I personally try to stay away from mysql queries when I can use WordPress functions to achieve the same thing. You could try using get_users, Is this what you are trying to achieve: <?php $blogusers = get_users(‘meta_value=Referral’); foreach ($blogusers as $user) { echo $user->user_email; } ?> Untested. But that should display every user with a … Read more
I know I probably can’t see the full picture, but in the excerpt you provided isn’t globalizing $post. global $wpdb, $post; $short = $wpdb->get_var(“SELECT url FROM $wpdb->prefix.’tweet_url’ WHERE post_id = ‘$post->ID’ “);
Nevermind, I was complicating this whole process because I wasn’t thinking about just using get_post_meta(). add_action(‘draft_to_publish’,’gcpl_draft_to_published’); function gcpl_draft_to_published($post){ $exp_processed = get_post_meta($post->ID, ‘_expiration-date-processed’, true); // check if the custom field has a value if($exp_processed != ”) { delete_post_meta($post->ID, ‘_expiration-date-processed’); } }
First you need permission to make changes in db of www.wordpress.domain.com. So for this you have to add the ip of wwww.wordpress.domain.com to www.doamin.com so that they allow to make changes. After that just make a function which allow you to connect to that server and make changes. The query for this is $pwd = … Read more
Well, after looking at the other tables I had created successfully, only difference was the description column. Apparently WordPress or MySQL doesn’t like that as a column name and somehow has it reserved. So, after renaming it, the table was created fine. Hope this helps someone else in the same boat.
You can use $args = array( ‘post_type’ => ‘post’ ,’posts_per_page’ => 10, ‘category_name’ => ‘orange’ ); $query = new WP_Query( $args ); printf( ‘<h2>Generated SQL:</h2><pre>%s</pre>’, $query->request ); to display the generated SQL query. The above example will give you: <h2>Generated SQL:</h2> <pre> SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE … Read more
Your Query is wrong beacuse your are searching for the user_id inside the meta_value column instead of the user_id column. In this case i see no point in creating a custom query just for that, So here is how you can do it using the native function get_user_meta $data = get_user_meta( get_current_user_id(), ‘bookmark_posts’ ); $number … Read more
Error inserting row into table