WordPress.org

Forums

I Recommend This
[resolved] most recommended post per category (2 posts)

  1. pictwee
    Member
    Posted 2 years ago #

    Hello!

    This plugin is great - I use it at http://www.pictwee.com - would it be possible to get the most recommended post of a specific category?

    I think I have to change this?!

    $request = "SELECT * FROM $wpdb->posts, $wpdb->postmeta";
    $request .= " WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id";
    $request .= " AND post_status='publish' AND post_type='$post_type' AND meta_key='_recommended'";
    $request .= " ORDER BY $wpdb->postmeta.meta_value+0 DESC LIMIT $numberOf";
    $posts = $wpdb->get_results($request);

    THANKS FOR YOUR HELP!!!

    http://wordpress.org/extend/plugins/i-recommend-this/

  2. Harish Chouhan
    Member
    Plugin Author

    Posted 2 years ago #

    Hello,

    yes you would need to write your own query. Are you planning to modify directly the source code of the plugin? If you do so, I hope you understand updates will break it.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • I Recommend This
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic