The results that i am getting from the the 2 fields with var_dump are:

for EVENT CATEGORIES

<pre>array(2) {
  [0]=>
  string(164) "<ul class="bpxcftr-multi-taxonomy-terms-list"><li><a href="">Walk</a></li></ul>"
  [1]=>
  string(152) "<ul class="bpxcftr-multi-taxonomy-terms-list"><li><a href="">Dance</a></li></ul>"
}
</pre>

for EVENT TAGS

<pre>array(3) {
  [0]=>
  string(128) "<ul class="bpxcftr-multi-taxonomy-terms-list"><li><a href="">Speak</a></li></ul>"
  [1]=>
  string(144) "<ul class="bpxcftr-multi-taxonomy-terms-list"><li><a href="">Read</a></li></ul>"
  [2]=>
  string(128) "<ul class="bpxcftr-multi-taxonomy-terms-list"><li><a href="">Think</a></li></ul>"
}
</pre>

So the results looks the same.

Hello Brajesh,

Thank you so much for your always kind help.
This is what i was also thinking. A filter would be good.
But still i am not so sure how i can create the entry after.

When you will push the update could you please help me with the attachment entry?

Thank you

Hello Ravi and thank you very much for your feedback 🙂

I would say approx 30-40 users in total that are not with a subscriber role: array( 'contributor', 'author', 'administrator' ) .

Thank you very much for your help

Hello Ravi

Thank you so much for your help 🙂
I was suspecting that your code is correct.
I have tried many different examples of codes and i really can’t understand why it gives me wrong results.

https://ibb.co/Z25Mw1x (keeps giving the oldest article)
https://ibb.co/RND6Dm7

It seems like the DESC doesn’t affect.

What i am trying to do is similar to previous https://buddydev.com/support/forums/topic/send-email-to-user-that-has-been-inactive-for-2-months/ :

With a cron job, send an email reminder to authors that have not published a post for the last 60 days.

So i am trying to create my function, something like this :

function reminder_email() {
	
       $days = 60; // if these days have passed from the last published post of the author send email reminder

	global $wpdb;
	
	// get the most recent post for each author
	$posts = $wpdb->get_results();

	// No post found.
	if ( empty( $posts ) ) {
		return;
	}

	
	if ( ! empty( $posts ) ) { 
	foreach( $posts as $post ) {
	
        // get today's date in unix timestamp format
		$today = strtotime( date( 'Y-m-d' ) );	
		
		// the date is X number of days from last post published date where X is set in the $days variable above
		$expire = strtotime( '+'. $days .'days', strtotime( $post->post_date ) );
		
	$user_info = get_userdata( $post->post_author );
	
	if ( $expire < $today ) { wp_mail();  //send email reminder to $user_info->user_email  }
       }
	}
}
add_action( 'reminder_email', 'reminder_email' );

I don’t understand why results from db are wrong.

• This reply was modified 2 years ago by Lefteris.

Hello Ravi

Thank you very much for your help 🙂
Unfortunately it didn’t work. Keeps giving me the oldest article for each author.