👻 Halloween Treat: Our biggest-ever 25% OFF memberships — use SPOOKYSOCIAL before Nov 1! 🎃

BuddyDev

Search

buddyblog display posts and custom post type at the same time

Tagged: 

  • Participant
    Level: Initiated
    Posts: 10
    richard gueron on October 3, 2015 at 7:50 pm #761

    I try this but no luck

    $count = $wpdb->get_var( $wpdb->prepare( “SELECT count(‘*’) FROM {$wpdb->posts} WHERE post_author=%d AND (post_status=’publish’||post_status=’draft’||post_type =’Concours’)”, $user_id ) );

  • Keymaster
    (BuddyDev Team)
    Posts: 25189
    Brajesh Singh on October 4, 2015 at 11:33 am #764

    Hi Richard,
    What is the post type name. ‘Concours’ is the label of that post type( seems to me as WordPress recommends using lower cases for the name )

    Also, If I understand it correctly, you want it for ‘post’ as well as ‘Concours’ both. Is that right?

  • Participant
    Level: Initiated
    Posts: 10
    richard gueron on October 4, 2015 at 6:40 pm #774

    Hello Brajesh, yes i want to have a total count of both posts and concours’posts from a user

  • Keymaster
    (BuddyDev Team)
    Posts: 25189
    Brajesh Singh on October 6, 2015 at 9:15 pm #779

    Hi Richard,
    Apologies for the delayed reply.
    here is the code

    

$count = $wpdb->get_var( $wpdb->prepare( "SELECT count('*') FROM {$wpdb->posts} WHERE post_author=%d AND ( post_type = 'post' || post_type ='concours' ) AND post_status='publish'", $user_id ) );

    Hope that helps.

  • Participant
    Level: Initiated
    Posts: 10
    richard gueron on October 12, 2015 at 8:30 pm #932

    Sorry for delay.

    It’s perfect thank you!

You must be logged in to reply to this topic.

This topic is: not resolved