You can filter the orderby part of the query to get what you want (trying to pass it via the orderby parameter will not work, it will be filtered out). This simple example adds the meta_value sort order before the standard title sort order. add_filter( ‘posts_orderby’, ‘wpse15168_posts_orderby’ ); $query = new WP_Query( array( ‘meta_key’ => … Read more
You will need to join four tables to get categories of custom post type “review” wp_term_relationships wp_posts wp_term_taxonomy wp_terms by using following query you can get list of categories applied to your custom post type: SELECT * FROM wp_term_relationships AS tr LEFT JOIN wp_posts AS p ON tr.object_id = p.ID LEFT JOIN wp_term_taxonomy AS tt … Read more
But am looking for a plugin or a code which can help me with adding this note every time I write a post. A shortcode to add that “note” is trivial. function note_sc_wpse_107275($atts,$content) { return ‘<p class=”note”><strong>’.$content.'</strong></p>’; } add_shortcode(‘note’,’note_sc_wpse_107275′); Then just add [note]Note content[/note] to your post body. That will give you exactly what you … Read more
Have a look at the $wpdb class, it does exactly what you want: $myrows = $wpdb->get_results( “SELECT id, name FROM mytable” ); Try to avoid SQL queries for basic operations though. WordPress offers you many convenience functions for 80% of the tasks you would every come up with. They provide a nicer interface and preserve … Read more
Here are two ideas for your date_query part: 1) After 2 days ago: If you need posts published after current time, 2 days ago: ‘date_query’ => array( array( ‘after’ => ‘2 days ago’, // or ‘-2 days’ ‘inclusive’ => true, ), ), then the corresponding SQL part is: post_date >= ‘2014-09-09 17:57:15’ if the current … Read more
You haven’t specified where you want this alteration to apply to so I’ve applied it to just the home page. You may alter to fit where this filter applies to: <?php function wpse10691_alter_query( $query ) { if ( $query->is_main_query() && ( $query->is_home() || $query->is_search() || $query->is_archive() ) ) { $query->set( ‘orderby’, ‘modified’ ); $query->set( ‘order’, … Read more
Don’t use $wpdb, use wp_query. Not only will your code be leaner and quicker, you’ll avoid issues like this. Unless you’re doing something with custom tables or seriously in-depth SQL, there’s no reason to do direct SQL calls on $wpdb. So, to answer your question – rewrite it from the ground up using wp_query, see … Read more
I was afraid you wanted that one. You can’t really do that. Follow the link for some workarounds. You could also set a variable or a constant in functions.php, or create a theme option for this. Then use that in your function. function smbd_cats_by_days ($where=””) { // global $days_limit; // if a variable // $days_limit … Read more
As you have stated, rank is defined by a value in a custom field, so you would just need to get the value from the custom field and display it. You can try the following inside your loop global $post; // Just make sure the custom field name is correct $rank = get_post_meta( $post->ID, ‘custom_field’, … Read more
try to work this into your query: ‘meta_key’ => ‘_thumbnail_id’ http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters