New
PeoplePress is here. Community building for WordPress, reimagined. Fast, modern, and built for the communities you've always wanted to run.
See it live

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: 25509
    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: 25509
    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