Skip to:
Content
Pages
Categories
Search
Top
Bottom

Get values from buddypress tables

  • Avatar of Kiran@Caret
    Kiran@Caret
    Participant

    @kirancaret

    Hi i have installed plugin, Mymoods on buddypress how can i show the statics of no of smiley used mostly, i have written small query to retrieve the data which i needed, how i can i write in buddypress or wordpress to convert what i want,
    Here is the query
    “SELECT `meta_value` , COUNT( * ) AS count
    FROM `wp_bp_activity_meta`
    WHERE `meta_key` = ‘mymood_mood’
    GROUP BY `meta_value`
    ORDER BY `count` DESC
    LIMIT 0 , 30

    I have red through the wordpress site http://codex.wordpress.org/Class_Reference/wpdb but not able to show any results, sorry for my english, any pointer how to start would be very helpful

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.