MySQL/SQL Queries Fetching Current and Previous Month Data

These queries are for fetching data for the last Months only not the days. :: SQL-Query For Fetching Current Data :: SELECT * FROM table_name WHERE MONTH(field_name) = MONTH(NOW) AND YEAR(field_name) = YEAR(NOW()); :: SQL-Query For Fetching Last One Month Data :: SELECT * FROM table_name WHERE MONTH(created) = (MONTH(CURRENT_DATE)-1); :: SQL-Query For Fetching Previous 3-Months Data :: SELECT * FROM table_name WHERE field_name BETWEEN (CURDATE() - INTERVAL 4 MONTH) AND (CURDATE() - (MONTH(CURRENT_DATE)-1)); <b>:: SQL-Query For Fetching Previous x-Months Data ::</b> SELECT * FROM table_name WHERE field_name BETWEEN (CURDATE() - INTERVAL (x+1) MONTH) AND (CURDATE() - (MONTH(CURRENT_DATE)-1));

Get target check box checked in post editor

When adding a link in the WP visual post editor you have to click the settings after adding the link and then click the Open link in a new tab to have it add a link with a target in a new window/tab. Here is the way to have this automatically checked by default.

Add this function in your theme's functions.php function my_enqueue($hook) { if ('post.php' != $hook ) { return; } wp_enqueue_script('my_custom_script', get_template_directory_uri() . '/js/myscript.js'); } add_action('admin_enqueue_scripts', 'my_enqueue'); In myscript.js place this code jQuery(document).ready(function(){ jQuery('#wp-link-target').prop("checked", true); })

Get Related Posts (Posts Under Same Category/Tags)

// get related posts $term_list = wp_get_post_terms(get_the_ID(), 'my_taxonomy', array("fields" => "ids")); $args = array( 'post_type' => 'my_post_type', 'post__not_in' => array(get_the_ID()), 'orderby' => 'rand', 'tax_query' => array( 'relation' => 'AND', array( 'taxonomy' => 'articles_cat', 'field' => 'term_id', 'terms' => $term_list, 'operator' => 'IN', ), ), ); $query = new WP_Query($args); while ( $query->have_posts() ) : $query->the_post(); echo $post->ID; echo $post->post_title; echo $post->post_content; echo '<img width="298" height="198" src="'.wp_get_attachment_url(get_post_thumbnail_id($post->ID)).'" u="image">'; echo get_permalink(); endwhile; wp_reset_query();