Can you use the SQL OFFSET statement: OFFSET 1 $query = “SELECT * FROM ” . $wpdb->base_prefix . “site_posts WHERE blog_public=”1″ AND post_type=”” . $recentglobalpoststype . “” ORDER BY post_published_stamp OFFSET 1 DESC LIMIT ” . $recentglobalpostsnumber;
When in multisite, the wpdb prefix is always the prefix required to access the tables for the current site. This includes the site ID so this should work: $wpdb->get_results($wpdb->prepare(“SELECT * FROM “.$wpdb->prefix.”options WHERE …..”)); There should be no difference at all when using multisite, just make your queries as if it were single site.
To get a specific post in WordPress, you can use the get_post() function and get_the_category() to get the categories associated with it. You can then use the code found in this answer to dump the SQL queries used. <?php $post_ID = 7; $the_post = get_post( $post_ID ); $the_category = get_the_category( $post_ID );
I agree with @Simon Blackbourn, but for arguments sake, here’s one technique: $data = get_user_meta( $user_id ); $data = wp_list_filter( $data, array( ‘ive-read-this’ ) ); $keys = array_keys( $data );
example: <?php query_posts(‘posts_per_page=5&order=ASC&post_status=future’); if ( !have_posts() ) query_posts(‘posts_per_page=5&order=DESC&post_status=publish’); if( have_posts() ) : while ( have_posts() ) : the_post(); ?>
You can’t alter a page query via pre_get_posts (in any fashion I’ve tried) to something other than a page query. If you look at the generated SQL, it’s trying to query all your post types for a pagename of new. If you set pagename to null, it’ll return posts, but it will disregard any taxonomy … Read more
ok not the most handsome solution but it works i transported the update function to update.php also wp-load.php $(“.col_visitor”).click(function(){ visitorID = $(this).attr(‘id’); //alert(‘testing ‘+visitorID); $.ajax({ url: ‘update.php’, data: {action: visitorID}, type: ‘post’, success: function(output) { //alert(output); window.location.reload(); //reload so we see the updated values } }); });//#end click
Arbitrary SQL query can be run via wpdb by using get_results() method: $results = $wpdb->get_results( $query ); You can work through documentation for wpdb at Codex to gain basic understanding of how it works.
You have to enclose the OR part to brackets: $sql = “SELECT ID,post_title,post_content,post_date,post_type FROM {$wpdb->posts} WHERE (post_content LIKE {$stuff}) AND post_status=”publish” AND post_type=”{$post_type}” AND ID != {$post->ID} LIMIT {$limit}”; $results= $wpdb->get_results($sql); Try this one: SELECT ID,post_title,post_content,post_date,post_type FROM wp_posts WHERE (post_content LIKE ‘%Battery%’ OR post_content LIKE ‘%Watcher%’ OR post_content LIKE ‘%Widget%’ OR post_content LIKE ‘%matches%’ OR … Read more
This seemed to work nicely for me; <?php $children = get_pages(‘child_of=”.$post->ID); if( count( $children ) != 0 ) { $id = $post->ID; } else { $id = $post->post_parent; } $args = array( “post_type’ => ‘page’, ‘post_parent’ => $id, ‘posts_per_page’ => -1 ); $system_query = new WP_Query($args); if ($system_query->have_posts()) : while ($system_query->have_posts()) : $system_query->the_post(); ?> <!– … Read more