Show category by latest post date

Question

I am working in a project where I am using below code to limit number of posts in each category. But I can't figure out how to sort these categories by latest posts. My code is working fine but when I add argument in wp query array, it does not sort or it breaks. I want to order the category with most recent post (date).

Can anyone guide me?

<?php $terms=g et_terms( array( 'taxonomy'=>'category', 'hide_empty' => false, ) ); foreach($terms as $cat){ $cata_name = $cat->name; $term_id = $cat->term_id; ?>
<?php //echo '<h3>'.$catname[0]->cat_name.'</h3>'; ?>
<?php $catqueryy=n ew WP_Query ( 'cat='.$term_id. '&posts_per_page=5');$count=$ catqueryy->found_posts; ?>

Sort the data when selecting it from the database. Use an order by and use the date column. — Blinkydamo, Oct 19 '16 at 08:38
I am using phpmyadmin module... these are my codes from wordpress.. — Kxplorer, Oct 19 '16 at 08:39
@devpro 'category', 'hide_empty' => false, ) ); foreach($terms as $cat){ $cata_name = $cat->name; $term_id = $cat->term_id; ?> — Kxplorer, Oct 19 '16 at 08:44
you can use arguments as `$args = array( 'post_type' => 'post', //your_post_type 'orderby' => 'date', //meta_value 'meta_query' => array(array('key' => 'cat','value'=>$term_id)), 'order' => 'DESC', 'posts_per_page' => 5, );` — devpro, Oct 19 '16 at 08:48

score 0 · Answer 1 · answered Oct 19 '16 at 08:45

0

You can add ORDER BY argument in wordpress as:

<?php
$args = array(
    'post_type'  => 'post', //your_post_type
    'orderby'    => 'date', //meta_value
    'meta_query' => array(array('key' => 'cat','value'=>$term_id)),
    'order'      => 'DESC',
    'posts_per_page' => 5,
);

$catqueryy = new WP_Query($args);
?>

You can explore the wordpress document: https://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters

answered Oct 19 '16 at 08:45

devpro

16,184
3
27
38

@Kryptex: ok let me chk – devpro Oct 19 '16 at 09:27
@Kryptex: read this: http://www.billerickson.net/code/wp_query-arguments/ i hope this will help – devpro Oct 19 '16 at 09:32

Show category by latest post date

1 Answers1